On Tue, May 16, 2006 at 07:24:43PM -0400, Sean Davis wrote:
> Jim C. Nasby wrote:
> >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.
>
> I have 4Gb of memory and the machine is pretty much a devoted database
> server. We use it mainly for data warehousing and mining; there are
> rarely more than 2 active connections and never more than 5 total, so I
> have felt pretty comfortable with leaving work_mem pretty generous. I
> will likely have to change that if the machine becomes more active.
Well, 10M of work_mem isn't exactly generous in that case, since you'd
probably end up using no more than 100M at once. Of course if you had
100 connections and only 1G, it'd be a different story...
--
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