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(at)sss(dot)pgh(dot)pa(dot)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" <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
>