Re: update query blows out

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: shane hill <shill(at)adobe(dot)com>
Cc: pgsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: update query blows out
Date: 2003-04-12 17:16:24
Message-ID: 18800.1050167784@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message shane hill 2003-04-12 18:14:55 Re: update query blows out
Previous Message shane hill 2003-04-12 17:14:52 update query blows out