On Mon, Dec 06, 2004 at 09:08:02AM -0500, David Esposito wrote: > shared_buffers = 131072 (roughly 1GB) > max_fsm_relations = 10000 > max_fsm_pages = 10000000 > sort_mem = 4096 > vacuum_mem = 262144 > Roughly 25 - 30 connections open (mostly idle) at any given time > (connection pools)
I'd suggest reducing shared_buffers to maybe a few thousand, there's really no point reserving so much memory that way, it just a waste. Secondly, up your sort_mem a bit to reflact how big your sorts are likely to be. How's your effective_cache_size? -- Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/ > Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a > tool for doing 5% of the work and then sitting around waiting for someone > else to do the other 95% so you can sue them.
pgpgbm6ddNySa.pgp
Description: PGP signature
