From: | shane hill <shill(at)adobe(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-performance <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: update query blows out |
Date: | 2003-04-12 18:14:55 |
Message-ID: | 3E98579F.8040904@adobe.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Postgres 7.3.1
The crash log is attached:
thank you very much!
-Shane
Tom Lane wrote:
>shane hill <shill(at)adobe(dot)com> writes:
>
>
>>I am having a problem with an update transaction. I need to update 4000+
>>records but the update query keeps blowing out postgres and at times I
>>am forced to restart the postmaster or reboot my server if I update
>>2500+ records. The query is fine with 2225 records it is just somewhere
>>beyond 2225 that brings the server down.
>>
>>
>
>What Postgres version? Can you get a backtrace from the core dump?
>
> regards, tom lane
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>http://archives.postgresql.org
>
>
>
>
Attachment | Content-Type | Size |
---|---|---|
postmaster.crash.log | text/plain | 33.0 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-04-12 20:53:23 | Re: update query blows out |
Previous Message | Tom Lane | 2003-04-12 17:16:24 | Re: update query blows out |