Re: No hash join across partitioned tables?
Greg Jaskiewicz <gryzman@gmail.com>
From: Grzegorz Jaśkiewicz <gryzman@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Robert Haas <robertmhaas@gmail.com>, Bruce Momjian <bruce@momjian.us>, Kris Jurka <books@ejurka.com>, pgsql-performance@postgresql.org
Date: 2010-03-02T16:27:14Z
Lists: pgsql-hackers, pgsql-performance
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. 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