From: | Gordon Shannon <gordo169(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: seg fault crashed the postmaster |
Date: | 2011-01-01 01:55:58 |
Message-ID: | AANLkTiktGQzo6DynsOqoK_N66U-vVDaFgtKmx1se5DDx@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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] <
ml-node+3323971-508486184-56124(at)n5(dot)nabble(dot)com<ml-node%2B3323971-508486184-56124(at)n5(dot)nabble(dot)com>
> 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: http://postgresql.1045698.n5.nabble.com/seg-fault-crashed-the-postmaster-tp3323117p3324015.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Dick Kniep | 2011-01-01 08:16:30 | Shit happens |
Previous Message | Tom Lane | 2010-12-31 22:42:33 | Re: seg fault crashed the postmaster |