Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id E3E6D6326EF for ; Tue, 2 Mar 2010 12:27:27 -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 68060-06 for ; Tue, 2 Mar 2010 16:27:16 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-bw0-f216.google.com (mail-bw0-f216.google.com [209.85.218.216]) by mail.postgresql.org (Postfix) with ESMTP id D8E8662DBF0 for ; Tue, 2 Mar 2010 12:27:16 -0400 (AST) Received: by bwz8 with SMTP id 8so353637bwz.3 for ; Tue, 02 Mar 2010 08:27:15 -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; bh=IlEBXld1jQKVQhDbrCY4gx9r4ttkjwbK2MEzY8jWu0Y=; b=cYRYxRIS74WDAZ47cwtr8utIos0+f0sJFEFYETfUqGtxXutVXD2L3iI5IQIf8o5FvO k0LluX3IVlER4BL+oyDfrxjRkp7x6igKeRN2YfVNfd4kadpzqqmkUTCqhIvA9m3lSv/Q OaitOKSYfG7wYztyMdEFne54fu6FtnmfNqcAI= 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; b=Ak2u9vlfKxNMyWVgmXOlfH3S/iJ+y7g+NmQLc2iT5DJTt9hQvWULRZ9waayXaKSKla RRxBqmwg3GwbV7x832v9bkzuApq8t1wd8iMqBeY/LxMGImd0d8auG0AlTRiE6IxGNqTJ Bb3n4NOYcNTFkGAk3q5q1iI7UPZeYvkYibnk0= MIME-Version: 1.0 Received: by 10.204.38.80 with SMTP id a16mr4579237bke.199.1267547234761; Tue, 02 Mar 2010 08:27:14 -0800 (PST) In-Reply-To: <17546.1267546998@sss.pgh.pa.us> References: <201002252346.o1PNkXG07892@momjian.us> <9477.1267142614@sss.pgh.pa.us> <603c8f071003020816j77b3ec63wbad0415df003c0f1@mail.gmail.com> <17546.1267546998@sss.pgh.pa.us> Date: Tue, 2 Mar 2010 16:27:14 +0000 Message-ID: <2f4958ff1003020827o76dfd233mbd0602093eb65c4a@mail.gmail.com> Subject: Re: No hash join across partitioned tables? From: =?UTF-8?Q?Grzegorz_Ja=C5=9Bkiewicz?= To: Tom Lane Cc: Robert Haas , Bruce Momjian , Kris Jurka , pgsql-performance@postgresql.org Content-Type: multipart/alternative; boundary=00032555a2d6aa2fd90480d3d62d X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.023 tagged_above=-10 required=5 tests=AWL=0.419, BAYES_00=-2.599, HTML_MESSAGE=0.001, SUBJECT_FUZZY_TION=0.156 X-Spam-Level: X-Archive-Number: 201003/22 X-Sequence-Number: 37847 --00032555a2d6aa2fd90480d3d62d Content-Type: text/plain; charset=UTF-8 On Tue, Mar 2, 2010 at 4:23 PM, Tom Lane wrote: > 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. > > I am pretty sure many people will appreciate it, even if it isn't going to be small. Is that stat collection across child tables any useful by it self ? -- GJ --00032555a2d6aa2fd90480d3d62d Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

On Tue, Mar 2, 2010 at 4:23 PM, Tom Lane= <tgl@sss.pgh.pa.= us> wrote:
Robert Haas <= robertmhaas@gmail.com> writes:
> On Thu, Feb 25, 2010 at 7:03 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Partially. =C2=A0There are stats now but a= utovacuum is not bright about
>> when to update them.

> Is that something you're planning to fix for 9.0? =C2=A0If 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 sm= all
enough that we want to put it in during beta.

I am pretty sure many people will appreciate it, even= if it isn't going to be small.
=C2=A0
Is that stat c= ollection across child tables any useful by it self ?

= --
GJ
--00032555a2d6aa2fd90480d3d62d--