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 A9B56D1B545 for ; Thu, 20 Nov 2003 21:12:16 +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 10172-07 for ; Thu, 20 Nov 2003 17:11:47 -0400 (AST) Received: from mail.libertyrms.com (unknown [209.167.124.227]) by svr1.postgresql.org (Postfix) with ESMTP id F25E8D1B4E6 for ; Thu, 20 Nov 2003 17:11:44 -0400 (AST) Received: from [10.1.2.130] (helo=dba2) by mail.libertyrms.com with esmtp (Exim 3.22 #3 (Debian)) id 1AMw5a-0006F3-00 for ; Thu, 20 Nov 2003 16:11:46 -0500 Received: by dba2 (Postfix, from userid 1019) id 5108BCBBA; Thu, 20 Nov 2003 16:11:46 -0500 (EST) Date: Thu, 20 Nov 2003 16:11:46 -0500 From: Andrew Sullivan To: PgSQL General ML Subject: Re: performance problem Message-ID: <20031120211146.GM9808@libertyrms.info> Mail-Followup-To: Andrew Sullivan , PgSQL General ML References: <021a01c3ae43$3b25a2f0$0700a8c0@trogdor> <8765hhqeks.fsf@asmodeus.mcnaught.org> <01a801c3afa6$a4290710$0700a8c0@trogdor> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <01a801c3afa6$a4290710$0700a8c0@trogdor> User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/1142 X-Sequence-Number: 52792 On Thu, Nov 20, 2003 at 01:41:13PM -0700, Rick Gigger wrote: > it says: "As a start for tuning, use 25% of RAM for cache size, and 2-4% for > sort size." It's an old rule of thumb which has been superseded by new tests. A -- ---- Andrew Sullivan 204-4141 Yonge Street Afilias Canada Toronto, Ontario Canada M2P 2A8 +1 416 646 3304 x110