On Tue, May 16, 2006 at 03:41:07PM -0400, Sean Davis wrote: > I had cranked things up a bit from the standard install. > > shared_buffers = 15000 # min 16 or max_connections*2, 8KB > each > #temp_buffers = 1000 # min 100, 8KB each > #max_prepared_transactions = 50 # can be 0 or more > work_mem = 10000 # min 64, size in KB > maintenance_work_mem = 128000 # min 1024, size in KB > max_stack_depth = 4096 # min 100, size in KB
You didn't say anything about how much memory you have, but you need to be careful with *work_mem, as being too agressive can run the machine out of memory. -- Jim C. Nasby, Sr. Engineering Consultant [EMAIL PROTECTED] Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
