Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 6AA36632D02 for ; Tue, 2 Mar 2010 12:23:32 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 66825-10 for ; Tue, 2 Mar 2010 16:23:21 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by mail.postgresql.org (Postfix) with ESMTP id 947C86329A7 for ; Tue, 2 Mar 2010 12:23:21 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id o22GNIMO017547; Tue, 2 Mar 2010 11:23:18 -0500 (EST) To: Robert Haas cc: Bruce Momjian , Kris Jurka , pgsql-performance@postgresql.org Subject: Re: No hash join across partitioned tables? In-reply-to: <603c8f071003020816j77b3ec63wbad0415df003c0f1@mail.gmail.com> References: <201002252346.o1PNkXG07892@momjian.us> <9477.1267142614@sss.pgh.pa.us> <603c8f071003020816j77b3ec63wbad0415df003c0f1@mail.gmail.com> Comments: In-reply-to Robert Haas message dated "Tue, 02 Mar 2010 11:16:51 -0500" Date: Tue, 02 Mar 2010 11:23:18 -0500 Message-ID: <17546.1267546998@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.38 tagged_above=-10 required=5 tests=AWL=0.063, BAYES_00=-2.599, SUBJECT_FUZZY_TION=0.156 X-Spam-Level: X-Archive-Number: 201003/20 X-Sequence-Number: 37845 Robert Haas writes: > On Thu, Feb 25, 2010 at 7:03 PM, Tom Lane wrote: >> Partially.  There are stats now but autovacuum is not bright about >> when to update them. > Is that something you're planning to fix for 9.0? If not, we at least > need to document what we intend for people to do about it. I want to look at it, but I'm not sure whether the fix will be small enough that we want to put it in during beta. regards, tom lane