pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Frank Knobbe <frank@knobbe.us>
To: Christopher Kings-Lynne <chriskl@familyhealth.com.au>
Cc: pgsql-performance@postgresql.org
Subject: Re: postgres 7.4 at 100%
Date: Sun, 27 Jun 2004 23:46:58 -0500
Message-ID: <1088397641.1105.10.camel@localhost> (raw)
In-Reply-To: <40DE5C25.6070805@familyhealth.com.au>
References: <e071108e04062423591d2b8aa9@mail.gmail.com>
	<40DBEBDF.3090605@archonet.com>
	<e071108e04062601087c442d5f@mail.gmail.com>
	<87llia78dj.fsf@asmodeus.mcnaught.org>
	<40DD8425.3080108@commandprompt.com>
	<e071108e0406261603650d1b58@mail.gmail.com>
	<40DE5C25.6070805@familyhealth.com.au>

On Sun, 2004-06-27 at 00:33, Christopher Kings-Lynne wrote:
> > 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.


Doug said the same, yet the PG Tuning article recommends not make this
too large as it is just temporary used by the query queue or so. (I
guess the system would benefit using more memory for file system cache)

So who is correct? The tuning article or big-honking-shared-mem
proponents?

FWIW: I have a box with 512 MB RAM and see no different between 4096 and
32758 shared buffers...

Regards,
Frank

Attachments:

  signature.asc (application/pgp-signature, 186B) download

view thread (24+ messages)  latest in thread

Message-ID: <1088397641.1105.10.camel@localhost>
Permalink:  ../1088397641.1105.10.camel@localhost/
Also on:    postgresql.org/message-id/1088397641.1105.10.camel@localhost

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: frank@knobbe.us, chriskl@familyhealth.com.au
  Subject: Re: postgres 7.4 at 100%
  In-Reply-To: <1088397641.1105.10.camel@localhost>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox