X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 1EFF230E3C6 for ; Tue, 10 Jun 2003 15:57:55 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 00729-10 for ; Tue, 10 Jun 2003 12:57:44 -0300 (ADT) Received: from www.pspl.co.in (www.pspl.co.in [202.54.11.65]) by svr1.postgresql.org (Postfix) with ESMTP id C0F9330DBF8 for ; Tue, 10 Jun 2003 12:57:41 -0300 (ADT) Received: (from root@localhost) by www.pspl.co.in (8.11.6/8.11.6) id h5AFveo25618 for ; Tue, 10 Jun 2003 21:27:40 +0530 Received: from daithan (daithan.intranet.pspl.co.in [192.168.7.161]) by www.pspl.co.in (8.11.6/8.11.0) with ESMTP id h5AFvd925613 for ; Tue, 10 Jun 2003 21:27:40 +0530 From: "Shridhar Daithankar" To: pgsql-performance@postgresql.org Date: Tue, 10 Jun 2003 21:26:49 +0530 MIME-Version: 1.0 Subject: Re: FW: [ADMIN] Shared_buffers and kernel parameters, tuning Reply-To: shridhar_daithankar@persistent.co.in Message-ID: <3EE64D19.30310.9E8DA9@localhost> References: In-reply-to: <200306100846.21875.josh@agliodbs.com> X-mailer: Pegasus Mail for Windows (v4.02) Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Content-description: Mail message body X-Archive-Number: 200306/31 X-Sequence-Number: 2115 On 10 Jun 2003 at 8:46, Josh Berkus wrote: > SHARED_BUFFERS > Sets the size of Postgres' memory buffer where queries are held before being > fed into the Kernel buffer of the host system. It's very important to > remember that this is only a holding area, and not the total memory available > for the server. As such, resist the urge to set this number to a large > portion of your RAM, as this will actually degrade performance on many OSes. > Members of the pgsql-performance mailing list have found useful values in the > range of 1000-6000, depending on available RAM, database size, and number of > concurrent queries. No one has yet reported positive results for any number > over 6000. I was planning to document postgresql.conf with little hints, enough to get one started, drawing inspiration from lilo.conf of debian, which is beautiful to say the least.. I haven't find enough time to do that. But I will do it.. But I don't know all the parameters enough. Of course I will post a starter but any input would be welcome. Point is we should be able to say RTFC rather than RTFA as that would get a DBA single place to look at. I agree that no amount of simplicity is enough but still..:-) Bye Shridhar -- Brooke's Law: Whenever a system becomes completely defined, some damn fool discovers something which either abolishes the system or expands it beyond recognition.