Re: postgres 7.4 at 100%

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Chris Cheston <ccheston(at)gmail(dot)com>
Cc: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>, Doug McNaught <doug(at)mcnaught(dot)org>, pgsql-performance(at)postgresql(dot)org
Subject: Re: postgres 7.4 at 100%
Date: 2004-06-27 05:33:25
Message-ID: 40DE5C25.6070805@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message P.A.M. van Dam 2004-06-27 17:25:20 Re: How can one see what queries are running withing a
Previous Message Chris Cheston 2004-06-26 23:03:19 Re: postgres 7.4 at 100%