Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.postgresql > #577
| Path | csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail |
|---|---|
| From | Dimitri Fontaine <dimitri@2ndQuadrant.fr> |
| Newsgroups | comp.databases.postgresql |
| Subject | Re: the performance cost of a postgresql key violation exception |
| Date | Sun, 20 Jul 2014 14:51:18 +0200 |
| Organization | A noiseless patient Spider |
| Lines | 13 |
| Message-ID | <m2lhrourax.fsf@2ndQuadrant.fr> (permalink) |
| References | <ed6a893b-3427-4f69-b574-2eb9d0d79b75@googlegroups.com> |
| Mime-Version | 1.0 |
| Content-Type | text/plain |
| Injection-Info | mx05.eternal-september.org; posting-host="b4cd7ce2dcd601d09567d71a2b24a9e9"; logging-data="18251"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX18InKer6tIvTbQdqBLrB3o2" |
| User-Agent | Gnus/5.13001 (Ma Gnus v0.10) Emacs/24.3.91 (darwin) |
| Cancel-Lock | sha1:AdY3cZv0ox7PJQHUHlfx4OzjCrQ= sha1:G8gUH98zpd5lQM8yb7phisqreu4= |
| Xref | csiph.com comp.databases.postgresql:577 |
Show key headers only | View raw
stoicism1@aol.com writes: > org.postgresql.util.PSQLException: ERROR: duplicate key value > violates unique constraint "reports_uniqueness_index" > > What is the cost performance of this? For PostgreSQL, an index lookup that it has to do anyway for inserting the new row at the right place. For your application, I don't know, you have to make some tests. -- Dimitri Fontaine PostgreSQL DBA, Architecte
Back to comp.databases.postgresql | Previous | Next — Previous in thread | Find similar
the performance cost of a postgresql key violation exception stoicism1@aol.com - 2014-07-19 11:07 -0700 Re: the performance cost of a postgresql key violation exception Dimitri Fontaine <dimitri@2ndQuadrant.fr> - 2014-07-20 14:51 +0200
csiph-web