| 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: | Whole Thread | Raw Message | 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 |