X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7F9E5D1B196 for ; Mon, 28 Jun 2004 01:47:11 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 44143-09 for ; Mon, 28 Jun 2004 04:47:09 +0000 (GMT) Received: from mail.praemunio.com (mail.praemunio.com [66.179.47.216]) by svr1.postgresql.org (Postfix) with SMTP id 32AE8D1B187 for ; Mon, 28 Jun 2004 01:47:05 -0300 (ADT) Received: from localhost (HELO mail.knobbe.us) by localhost with SMTP; 27 Jun 2004 23:47:04 -0500 Received: from localhost (HELO ??) by localhost with SMTP; 27 Jun 2004 23:47:01 -0500 Subject: Re: postgres 7.4 at 100% From: Frank Knobbe To: Christopher Kings-Lynne Cc: pgsql-performance@postgresql.org In-Reply-To: <40DE5C25.6070805@familyhealth.com.au> References: <40DBEBDF.3090605@archonet.com> <87llia78dj.fsf@asmodeus.mcnaught.org> <40DD8425.3080108@commandprompt.com> <40DE5C25.6070805@familyhealth.com.au> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-c14bXWLYqKeKySi/hCZM" Message-Id: <1088397641.1105.10.camel@localhost> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 Date: Sun, 27 Jun 2004 23:46:58 -0500 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/270 X-Sequence-Number: 7328 --=-c14bXWLYqKeKySi/hCZM Content-Type: text/plain Content-Transfer-Encoding: quoted-printable 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. >=20 > You need to greatly incrase the shared memory max setting on your=20 > 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 --=-c14bXWLYqKeKySi/hCZM Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (FreeBSD) iD4DBQBA36FJJjGc5ftAw8wRAn8AAJiGwf9Yy6lBXO1BwfgXMZkm55G0AKCLSJuM lP6gBaVD1ssMfYElPDwLEg== =CYVa -----END PGP SIGNATURE----- --=-c14bXWLYqKeKySi/hCZM--