Re: seg fault crashed the postmaster

Поиск
Список
Период
Сортировка
От Gordon Shannon
Тема Re: seg fault crashed the postmaster
Дата
Msg-id AANLkTiktGQzo6DynsOqoK_N66U-vVDaFgtKmx1se5DDx@mail.gmail.com
обсуждение исходный текст
Ответ на Re: seg fault crashed the postmaster  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: seg fault crashed the postmaster
Список pgsql-general
Unfortunately it's now impossible to say how many were updated, as they get deleted by another process later. I may be able to restore part of a dump from 2 days ago on another machine, and get some counts from that, assuming I have the disk space.  I'll work on that.

I do not believe there could have been more than 2 concurrent updates because the app is limited to 2 threads, but I will verify that with the developer.

-gordon

On Fri, Dec 31, 2010 at 3:43 PM, Tom Lane-2 [via PostgreSQL] <[hidden email]> wrote:


No luck here either.  A couple further questions --- do you think it's
likely that you could have been over 10000 matches, ie, the LIMIT
actually kicked in?  Also, could there have been more than two
concurrent updates acting on the same rows?



View this message in context: Re: seg fault crashed the postmaster
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: seg fault crashed the postmaster
Следующее
От: Dick Kniep
Дата:
Сообщение: Shit happens