X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 5087D9FA613 for ; Mon, 11 Sep 2006 21:57:00 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 69836-02 for ; Mon, 11 Sep 2006 21:56:51 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from stark.xeocode.com (stark.xeocode.com [216.58.44.227]) by postgresql.org (Postfix) with ESMTP id 625989FA374 for ; Mon, 11 Sep 2006 21:56:52 -0300 (ADT) Received: from localhost ([127.0.0.1] helo=stark.xeocode.com) by stark.xeocode.com with smtp (Exim 3.36 #1 (Debian)) id 1GMwZf-0002Nk-00; Mon, 11 Sep 2006 20:56:27 -0400 To: Florian Weimer Cc: Tom Lane , pgsql-performance@postgresql.org Subject: Re: Abysmal hash join References: <821wqiy0oc.fsf@mid.bfk.de> <22641.1157984931@sss.pgh.pa.us> <82wt8awi21.fsf@mid.bfk.de> <3204.1157989198@sss.pgh.pa.us> <82sliyweny.fsf@mid.bfk.de> From: Gregory Stark In-Reply-To: <82sliyweny.fsf@mid.bfk.de> Date: 11 Sep 2006 20:56:27 -0400 Message-ID: <87k649q4w4.fsf@stark.xeocode.com> Lines: 12 User-Agent: Gnus/5.09 (Gnus v5.9.0) Emacs/21.4 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.077 tagged_above=0 required=5 tests=AWL, SPF_SOFTFAIL X-Spam-Level: * X-Archive-Number: 200609/70 X-Sequence-Number: 20756 Florian Weimer writes: > I've done that. Fortunately, ANALYZE time didn't increase by that > much, compared to the default (by just a factor of 10). With really high stats times you also have to keep an eye on planning time. The extra data in the stats table can cause planning to take longer. -- greg