Postgres Pro
Downloads
Home   >   mailing lists

Re: 50K record DELETE Begins, 100% CPU, Never Completes 1 hour later - Mailing list pgsql-general

From Tom Lane
Subject Re: 50K record DELETE Begins, 100% CPU, Never Completes 1 hour later
Date
Msg-id 611.1063310390@sss.pgh.pa.us
Whole thread Raw
In response to Re: 50K record DELETE Begins, 100% CPU, Never Completes 1 hour later  ("Clay Luther" <claycle@cisco.com>)
List pgsql-general
Tree view 
"Clay Luther" <claycle@cisco.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

pgsql-general by date:

Previous
From: Sean Chittenden
Date:
Subject: Re: State of Beta 2
Next
From: "Clay Luther"
Date:
Subject: Re: 50K record DELETE Begins, 100% CPU, Never Completes 1 hour later