Thread: Re: [PERFORM] NOT IN query takes forever

Re: [PERFORM] NOT IN query takes forever

From
Marius Andreiana
Date:
On Tue, 2004-08-03 at 19:28 +0200, Gaetano Mendola wrote:
> > With
> > shared_buffers = 3000        # min 16, at least max_connections*2, 8KB each
> > sort_mem = 128000        # min 64, size in KB
>
> 128 MB for sort_mem is too much, consider that in this way each backend can
> use 128 MB for sort operations...
> Also shared_buffers = 3000 means 24MB  that is not balanced with the 128MB
> needed for sort...
> Try to bump up 128 MB for shared_buffer ( may be you need to instruct your
> OS to allow that ammount of shared memory usage ) and 24MB for sort_mem.
Thanks for the advice. I increased shmmax to allow shared_buffers to be
128mb and set sort_mem to 24mb.

--
Marius Andreiana
Galuna - Solutii Linux in Romania
http://www.galuna.ro