Re: update query blows out - Mailing list pgsql-performance

From Tom Lane
Subject Re: update query blows out
Date
Msg-id 18800.1050167784@sss.pgh.pa.us
Whole thread Raw
In response to update query blows out  (shane hill <shill@adobe.com>)
List pgsql-performance
shane hill <shill@adobe.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


pgsql-performance by date:

Previous
From: shane hill
Date:
Subject: update query blows out
Next
From: shane hill
Date:
Subject: Re: update query blows out