Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 0B29A1337BD0 for ; Fri, 4 Mar 2011 13:00:37 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 94785-09 for ; Fri, 4 Mar 2011 17:00:29 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail.optrak.co.uk (mail.optrak.co.uk [217.206.42.18]) by mail.postgresql.org (Postfix) with ESMTP id 9719C1337BCE for ; Fri, 4 Mar 2011 13:00:29 -0400 (AST) Received: from mail.optrak.co.uk ([217.206.42.18] helo=[192.168.41.82]) by mail.optrak.co.uk with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.71) (envelope-from ) id 1PvYMe-00080L-7N for pgsql-performance@postgresql.org; Fri, 04 Mar 2011 17:00:28 +0000 Message-ID: <4D711AAB.5010801@optrak.co.uk> Date: Fri, 04 Mar 2011 17:00:27 +0000 From: Mark Thornton User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-GB; rv:1.9.2.13) Gecko/20101207 Thunderbird/3.1.7 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Slow join on partitioned table References: <4D70CFC7.5050805@optrak.co.uk> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201103/50 X-Sequence-Number: 42729 On 04/03/2011 16:07, Robert Haas wrote: > That seems quite surprising. There are only 14 rows in the table but > PG thinks 2140? Do you have autovacuum turned on? Has this table > been analyzed recently? > I think autovacuum is enabled, but as a temporary table LinkIds has only existed for a very short time (at least in my current tests). Mark