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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org