Re: 50K record DELETE Begins, 100% CPU, Never Completes 1 hour later

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Clay Luther" <claycle(at)cisco(dot)com>
Cc: "Pgsql-General (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: Re: 50K record DELETE Begins, 100% CPU, Never Completes 1 hour later
Date: 2003-09-11 19:59:50
Message-ID: 611.1063310390@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Clay Luther" <claycle(at)cisco(dot)com> writes:
> Sort_mem is 32K.

Try more (like 32M). Particularly in 7.4, you can really hobble a query
by starving it for sort memory (since that also determines whether
hashtable techniques will be tried).

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Marc G. Fournier 2003-09-11 20:05:07 Re: State of Beta 2
Previous Message Sean Chittenden 2003-09-11 19:24:39 Re: State of Beta 2