Re: seg fault crashed the postmaster - Mailing list pgsql-general

From Gordon Shannon
Subject Re: seg fault crashed the postmaster
Date
Msg-id AANLkTiktGQzo6DynsOqoK_N66U-vVDaFgtKmx1se5DDx@mail.gmail.com
Whole thread Raw
In response to Re: seg fault crashed the postmaster  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: seg fault crashed the postmaster
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: seg fault crashed the postmaster
Next
From: Dick Kniep
Date:
Subject: Shit happens