From: | "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com> |
---|---|
To: | Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> |
Cc: | Tony Wasson <ajwasson(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: FATAL: could not read statistics message |
Date: | 2006-05-16 20:56:17 |
Message-ID: | 20060516205617.GY26212@pervasive.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
From | Date | Subject | |
---|---|---|---|
Next Message | Joshua D. Drake | 2006-05-16 21:12:04 | Re: Announce: GPL Framework centered on Postgres |
Previous Message | Jim C. Nasby | 2006-05-16 20:54:13 | Re: problems with postgresql 9 |