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

By 32K I meant:

sort_mem = 32768                        # min 64, size in KB

Do you mean to say that this should be

sort_mem = 33554432

?

Thanks.

cwl


> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: Thursday, September 11, 2003 3:00 PM
> To: Clay Luther
> Cc: Pgsql-General (E-mail)
> Subject: Re: [GENERAL] 50K record DELETE Begins, 100% CPU, Never
> Completes 1 hour later 
> 
> 
> "Clay Luther"  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
>