Are WALs affected by 'duplicate key' errors?

Поиск
Список
Период
Сортировка
От Jeff Boes
Тема Are WALs affected by 'duplicate key' errors?
Дата
Msg-id 9t3fpr$2o5a$1@news.tht.net
обсуждение исходный текст
Ответы Re: Are WALs affected by 'duplicate key' errors?
Список 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 по дате отправления:

Предыдущее
От: "Jeff Boes"
Дата:
Сообщение: Upgrading 7.1.2 to .3
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Are WALs affected by 'duplicate key' errors?