Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group