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 36823D1B55D for ; Thu, 20 Nov 2003 22:22: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 20406-09 for ; Thu, 20 Nov 2003 18:21:51 -0400 (AST) Received: from b0x.supernerd.com (unknown [208.186.134.90]) by svr1.postgresql.org (Postfix) with ESMTP id A6EF6D1D450 for ; Thu, 20 Nov 2003 18:21:48 -0400 (AST) Received: from trogdor (unknown [67.42.122.198]) by b0x.supernerd.com (Postfix) with ESMTP id A88325FFF2; Thu, 20 Nov 2003 15:18:00 -0700 (MST) Message-ID: <01e401c3afb4$b56cdb10$0700a8c0@trogdor> From: "Rick Gigger" To: "Tom Lane" Cc: "Doug McNaught" , "scott.marlowe" , "PgSQL General ML" References: <021a01c3ae43$3b25a2f0$0700a8c0@trogdor> <8765hhqeks.fsf@asmodeus.mcnaught.org> <01a801c3afa6$a4290710$0700a8c0@trogdor> <6890.1069363150@sss.pgh.pa.us> Subject: Re: performance problem Date: Thu, 20 Nov 2003 15:21:55 -0700 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/1150 X-Sequence-Number: 52800 > "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 Thank you!