X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8229ADA5FB for ; Wed, 9 Nov 2005 20:44:39 -0400 (AST) 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 52845-10 for ; Thu, 10 Nov 2005 00:44:36 +0000 (GMT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mx1.surnet.cl (mx1.surnet.cl [216.155.73.180]) by svr1.postgresql.org (Postfix) with ESMTP id 8AD7FDA4D7 for ; Wed, 9 Nov 2005 20:44:36 -0400 (AST) Received: from unknown (HELO cluster.surnet.cl) ([216.155.73.165]) by mx1.surnet.cl with ESMTP; 09 Nov 2005 21:45:44 -0300 X-IronPort-AV: i="3.97,310,1125892800"; d="scan'208"; a="24361317:sNHT146117720810" Received: from alvh.no-ip.org (216.155.78.23) by cluster.surnet.cl (7.0.043) (authenticated as alvherre@surnet.cl) id 435015970034B36A; Wed, 9 Nov 2005 21:43:20 -0300 Received: by alvh.no-ip.org (Postfix, from userid 1000) id 20543C2D450; Wed, 9 Nov 2005 21:43:33 -0300 (CLST) Date: Wed, 9 Nov 2005 21:43:33 -0300 From: Alvaro Herrera To: Frank Wiles Cc: rjpeace@earthlink.net, yves.vindevogel@implements.be, pgsql-performance@postgresql.org Subject: Re: Some help on buffers and other performance tricks Message-ID: <20051110004332.GE8230@surnet.cl> Mail-Followup-To: Frank Wiles , rjpeace@earthlink.net, yves.vindevogel@implements.be, pgsql-performance@postgresql.org References: <17035565.1131571489652.JavaMail.root@elwamui-hound.atl.sa.earthlink.net> <20051109230752.GC8230@surnet.cl> <20051109175332.3edbd5fc.frank@wiles.org> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <20051109175332.3edbd5fc.frank@wiles.org> User-Agent: Mutt/1.5.10i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.12 required=5 tests=[AWL=0.793, RCVD_IN_NJABL_PROXY=0.327] X-Spam-Score: 1.12 X-Spam-Level: * X-Archive-Number: 200511/168 X-Sequence-Number: 15425 Frank Wiles wrote: > Obviously there are systems/datasets/quantities where this won't > always work out best, but for the majority of systems out there > complicating your schema, maxing your hardware, and THEN tuning > is IMHO the wrong approach. I wasn't suggesting to complicate the schema -- I was actually thinking in systems where some queries are not using indexes, some queries are plain wrong, etc. Buying a very expensive RAID and then noticing that you just needed to create an index, is going to make somebody feel at least somewhat stupid. -- Alvaro Herrera Valdivia, Chile ICBM: S 39º 49' 17.7", W 73º 14' 26.8" Y una voz del caos me habló y me dijo "Sonríe y sé feliz, podría ser peor". Y sonreí. Y fui feliz. Y fue peor.