X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 2695CD1B555 for ; Thu, 20 Nov 2003 21:20:20 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 18365-04 for ; Thu, 20 Nov 2003 17:19:50 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id CFD49D1B578 for ; Thu, 20 Nov 2003 17:19:47 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.10/8.12.10) with ESMTP id hAKLJA19006891; Thu, 20 Nov 2003 16:19:10 -0500 (EST) To: "Rick Gigger" Cc: "Doug McNaught" , "scott.marlowe" , "PgSQL General ML" Subject: Re: performance problem In-reply-to: <01a801c3afa6$a4290710$0700a8c0@trogdor> References: <021a01c3ae43$3b25a2f0$0700a8c0@trogdor> <8765hhqeks.fsf@asmodeus.mcnaught.org> <01a801c3afa6$a4290710$0700a8c0@trogdor> Comments: In-reply-to "Rick Gigger" message dated "Thu, 20 Nov 2003 13:41:13 -0700" Date: Thu, 20 Nov 2003 16:19:10 -0500 Message-ID: <6890.1069363150@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/1147 X-Sequence-Number: 52797 "Rick Gigger" writes: > I am confused. In this tutorial (by Bruce Momjian) > http://candle.pha.pa.us/main/writings/pgsql/hw_performance/node8.html > it says: "As a start for tuning, use 25% of RAM for cache size, and 2-4% for > sort size." That advice is widely considered obsolete --- it was developed in the days when typical RAM sizes were a lot less than today. I don't believe anyone has shown a good case for setting shared_buffers much higher than 10000. regards, tom lane