X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7EBEC55F03 for ; Sun, 27 Feb 2005 10:58:14 +0000 (GMT) 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 98400-07 for ; Sun, 27 Feb 2005 10:57:59 +0000 (GMT) Received: from mta09-winn.mailhost.ntl.com (smtpout17.mailhost.ntl.com [212.250.162.17]) by svr1.postgresql.org (Postfix) with ESMTP id 07C99563A8 for ; Sun, 27 Feb 2005 10:58:04 +0000 (GMT) Received: from aamta04-winn.mailhost.ntl.com ([212.250.162.8]) by mta09-winn.mailhost.ntl.com with ESMTP id <20050227105812.FWVV29900.mta09-winn.mailhost.ntl.com@aamta04-winn.mailhost.ntl.com> for ; Sun, 27 Feb 2005 10:58:12 +0000 Received: from Wilbur ([81.96.74.213]) by aamta04-winn.mailhost.ntl.com with SMTP id <20050227105812.HAPW13480.aamta04-winn.mailhost.ntl.com@Wilbur> for ; Sun, 27 Feb 2005 10:58:12 +0000 Message-ID: <029a01c51cbb$3ed844b0$0600a8c0@Wilbur> From: "Julian Scarfe" To: "postgresql-general mailing list" References: <421F3926.6090201@graciousstyle.com> <5708.1109348115@sss.pgh.pa.us> Subject: Re: postgresql 8.0 advantages Date: Sun, 27 Feb 2005 10:58:16 -0000 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="Windows-1252"; reply-type=original Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2527 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200502/1419 X-Sequence-Number: 74223 From: "Tom Lane" > There are some speed improvements in 8.0 too, though that wasn't the > main focus of the release cycle. For instance, Lonni Friedman's nearby > thread reports on a case where 8.0 consistently finds a much better > query plan for a complex query than prior releases did, because we fixed > some issues in the GEQO planner module. Could you give an example or two of the sorts of queries for which performance is improved under 8.0 compared with 7.4, please Tom? Thanks Julian Scarfe