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 jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461