Re: postgres 7.4 at 100% - Mailing list pgsql-performance

From Christopher Kings-Lynne
Subject Re: postgres 7.4 at 100%
Date
Msg-id 40DE5C25.6070805@familyhealth.com.au
Whole thread Raw
In response to Re: postgres 7.4 at 100%  (Chris Cheston <ccheston@gmail.com>)
Responses Re: postgres 7.4 at 100%
List pgsql-performance
> I upped effective_cache to 16000 KB and I could only up the
> shared_buffers to 3000.  Anything more and postgres would not start.

You need to greatly incrase the shared memory max setting on your
machine so that you can use at the very least, 10000 shared buffers.

Chris


pgsql-performance by date:

Previous
From: Chris Cheston
Date:
Subject: Re: postgres 7.4 at 100%
Next
From: Jim
Date:
Subject: SQL stupid query plan... terrible performance !