Are WALs affected by 'duplicate key' errors? - Mailing list pgsql-admin

From Jeff Boes
Subject Are WALs affected by 'duplicate key' errors?
Date
Msg-id 9t3fpr$2o5a$1@news.tht.net
Whole thread Raw
Responses Re: Are WALs affected by 'duplicate key' errors?
List pgsql-admin
A grim suspicion begins to dawn on me ...

We have an application that attempts many insertions into a table,
detecting the prior existance of the row by whether we get a 'duplicate
key in unique index' error.  When this application is running as multiple
copies and really cranking, we get 130K or more of these in a day.  Are
these filling up (and possibly messing up) our WALs?  We have experienced
a few shared-memory corruption errors, and a full-blown corruption
(although of a different table).


--
Jeff Boes                                             vox 616.226.9550
Database Engineer                                     fax 616.349.9076
Nexcerpt, Inc.                                      jboes@nexcerpt.com

pgsql-admin by date:

Previous
From: "Jeff Boes"
Date:
Subject: Upgrading 7.1.2 to .3
Next
From: Tom Lane
Date:
Subject: Re: Are WALs affected by 'duplicate key' errors?