X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id B47CCD1E94D for ; Sun, 18 Apr 2004 00:34:16 -0300 (ADT) 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 10187-07 for ; Sun, 18 Apr 2004 00:34:15 -0300 (ADT) Received: from linda-1.paradise.net.nz (bm-1a.paradise.net.nz [202.0.58.20]) by svr1.postgresql.org (Postfix) with ESMTP id 61C65D1E949 for ; Sun, 18 Apr 2004 00:34:14 -0300 (ADT) Received: from smtp-2.paradise.net.nz (smtp-2b.paradise.net.nz [202.0.32.211]) by linda-1.paradise.net.nz (Paradise.net.nz) with ESMTP id <0HWC002VOKL0AQ@linda-1.paradise.net.nz> for pgsql-performance@postgresql.org; Sun, 18 Apr 2004 15:34:13 +1200 (NZST) Received: from paradise.net.nz (203-96-145-144.adsl.paradise.net.nz [203.96.145.144]) by smtp-2.paradise.net.nz (Postfix) with ESMTP id 36AEB9E29A; Sun, 18 Apr 2004 15:34:12 +1200 (NZST) Date: Sun, 18 Apr 2004 15:35:58 +1200 From: Mark Kirkwood Subject: Re: Poor performance of group by query In-reply-to: <20040416151706.GE87362@nasby.net> To: "Jim C. Nasby" Cc: pgsql-performance@postgresql.org Message-id: <4081F79E.6070409@paradise.net.nz> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=us-ascii Content-transfer-encoding: 7bit X-Accept-Language: en-us, en User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.6) Gecko/20040404 References: <20040416151706.GE87362@nasby.net> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/239 X-Sequence-Number: 6539 It might be worth trying out a build with -O2, just to rule out any -O3 oddness. regards Mark Jim C. Nasby wrote: > PostgreSQL 7.4.2 compiled with -O3. > > > >