X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 53D80D1B45A for ; Mon, 8 Dec 2003 19:21:38 +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 77846-05 for ; Mon, 8 Dec 2003 15:21:10 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 5BCDDD1B448 for ; Mon, 8 Dec 2003 15:21:09 -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 hB8JJw19022186; Mon, 8 Dec 2003 14:19:59 -0500 (EST) To: Jack Coates Cc: pgsql-performance Subject: Re: tuning questions In-reply-to: <1070905424.16088.63.camel@cletus.lyris.com> References: <1070553983.6498.52.camel@cletus.lyris.com> <200312042347.54461.dev@archonet.com> <1070584326.18838.235.camel@cletus.lyris.com> <200312050926.05155.josh@agliodbs.com> <1070673761.13542.534.camel@cletus.lyris.com> <1070905424.16088.63.camel@cletus.lyris.com> Comments: In-reply-to Jack Coates message dated "Mon, 08 Dec 2003 09:43:45 -0800" Date: Mon, 08 Dec 2003 14:19:58 -0500 Message-ID: <22185.1070911198@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/156 X-Sequence-Number: 5016 Jack Coates writes: > Theories at this point, in no particular order: > a) major differences between my 7.3.4 from source (compiled with no > options) and dev's 7.3.2-1PGDG RPMs. Looking at the spec file doesn't > reveal anything glaring to me, but is there something I'm missing? There are quite a few performance-related patches between 7.3.2 and 7.3.4. Most of them should be in 7.3.4's favor but there are some places where we had to take a performance hit in order to have a suitably low-risk fix for a bug. You haven't told us enough about the problem to know if any of those cases apply, though. AFAIR you have not actually showed either the slow query or EXPLAIN ANALYZE results for it on the two boxes ... regards, tom lane