Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 1253F632B8A for ; Tue, 2 Mar 2010 12:18:02 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 96406-04 for ; Tue, 2 Mar 2010 16:17:51 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-fx0-f223.google.com (mail-fx0-f223.google.com [209.85.220.223]) by mail.postgresql.org (Postfix) with ESMTP id 59CB76326EF for ; Tue, 2 Mar 2010 12:17:51 -0400 (AST) Received: by fxm23 with SMTP id 23so316fxm.3 for ; Tue, 02 Mar 2010 08:17:50 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:cc:content-type :content-transfer-encoding; bh=3185xqrxhUDBLVagMV4oTI0eDjfIgZEbZhn6tZtwifo=; b=Y1G4RAuq7+TpIdpwthyo+bTV8cv/Buw3a9oc5qoDVTHb/m3ktpIPEEkn6o7cTp3zUy KCPERcPq96yC65il6u/mEpPyBtGCOq59wAQCs0LtpOvPg1TJm/c8QW9W2fQOrWQ3S8qL Ay2a7Gon9ldq0fyXoD5RMCLZJv1xIhsK4V6Nw= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type:content-transfer-encoding; b=vzZk96MyYS5DvGnI/uKwIbIHLgO+y+Xuyh/4hqj7qx0cmgDfw9HafwsSjKVgZWEb60 DYOxXgSXcggZC/ZEWA2UCPYQlgXA+ry6oDtPyjmQnpVNew7jY6BVBIKH7hctIR4NTCth sWaIjDBdiLZ7GAXFn8NIg4zZTZgLeCuQNLmA8= MIME-Version: 1.0 Received: by 10.239.146.210 with SMTP id x18mr526633hba.77.1267546611467; Tue, 02 Mar 2010 08:16:51 -0800 (PST) In-Reply-To: <9477.1267142614@sss.pgh.pa.us> References: <201002252346.o1PNkXG07892@momjian.us> <9477.1267142614@sss.pgh.pa.us> Date: Tue, 2 Mar 2010 11:16:51 -0500 Message-ID: <603c8f071003020816j77b3ec63wbad0415df003c0f1@mail.gmail.com> Subject: Re: No hash join across partitioned tables? From: Robert Haas To: Tom Lane Cc: Bruce Momjian , Kris Jurka , pgsql-performance@postgresql.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.443 tagged_above=-10 required=5 tests=BAYES_00=-2.599, SUBJECT_FUZZY_TION=0.156 X-Spam-Level: X-Archive-Number: 201003/18 X-Sequence-Number: 37843 On Thu, Feb 25, 2010 at 7:03 PM, Tom Lane wrote: > Bruce Momjian writes: >> Did this get addressed? > > Partially. =A0There 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. ...Robert