From:
Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:
Robert Haas <robertmhaas(at)gmail(dot)com>, Bruce Momjian <bruce(at)momjian(dot)us>, Kris Jurka <books(at)ejurka(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject:
Re: No hash join across partitioned tables?
Date:
2010-03-02 16:27:14
Message-ID:
2f4958ff1003020827o76dfd233mbd0602093eb65c4a@mail.gmail.com (view raw or flat )
Thread:
2009-04-16 23:09:37 from Kris Jurka <books(at)ejurka(dot)com>
2009-04-16 23:12:11 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-04-16 23:30:51 from Kris Jurka <books(at)ejurka(dot)com>
2009-04-17 01:02:04 from Kris Jurka <books(at)ejurka(dot)com>
2009-04-17 15:02:34 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-04-17 15:07:21 from Kris Jurka <books(at)ejurka(dot)com>
2009-04-17 15:08:24 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2009-04-17 17:05:32 from Kris Jurka <books(at)ejurka(dot)com>
2009-04-19 23:31:51 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-02-25 23:46:33 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-02-26 00:03:34 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-03-02 16:16:51 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-03-02 16:23:18 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-03-02 16:27:14 from Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
2010-06-09 19:47:55 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-09 20:11:25 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-06-10 13:29:41 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-10 14:42:18 from "Luxenberg, Scott I(dot)" <Scott(dot)Luxenberg(at)noblis(dot)org>
2010-06-10 15:26:59 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2010-06-10 15:44:16 from Stephen Frost <sfrost(at)noblis(dot)org>
2010-06-10 16:15:56 from Andrew Dunstan <andrew(at)dunslane(dot)net>
2010-06-10 16:20:29 from Stephen Frost <sfrost(at)snowman(dot)net>
2010-06-10 17:30:00 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-06-11 17:12:26 from Andres Freund <andres(at)anarazel(dot)de>
2010-06-11 17:19:50 from Magnus Hagander <magnus(at)hagander(dot)net>
2010-06-30 22:22:09 from Daniel Farina <drfarina(at)acm(dot)org>
2010-06-10 19:23:47 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-06-11 07:43:16 from Leonardo F <m_lists(at)yahoo(dot)it>
2010-06-14 03:47:06 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-06-15 18:44:32 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-07-02 03:00:00 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-07-02 04:05:04 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-07-02 20:53:44 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-07-02 20:58:45 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-07-02 21:10:58 from Robert Haas <robertmhaas(at)gmail(dot)com>
2010-07-02 21:12:22 from Bruce Momjian <bruce(at)momjian(dot)us>
2010-10-16 05:03:02 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-10-16 05:22:42 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
2010-10-16 05:35:46 from Samuel Gendler <sgendler(at)ideasculptor(dot)com>
2010-10-16 15:29:39 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-10-18 06:13:01 from Samuel Gendler <sgendler(at)ideasculptor(dot)com>
2010-10-18 14:44:53 from Alvaro Herrera <alvherre(at)commandprompt(dot)com>
2010-10-26 12:23:26 from Robert Haas <robertmhaas(at)gmail(dot)com>
Lists:
pgsql-hackers pgsql-performance
On Tue, Mar 2, 2010 at 4:23 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Robert Haas <robertmhaas(at)gmail(dot)com> writes:
> > On Thu, Feb 25, 2010 at 7:03 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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
In response to
pgsql-performance by date
Next :From: Francisco ReyesDate: 2010-03-02 20:42:37Subject : 10K vs 15k rpm for analyticsPrevious :From : Robert HaasDate : 2010-03-02 16:23:22Subject : Re: GiST index performance
pgsql-hackers by date
Next :From: Tom LaneDate: 2010-03-02 16:29:58Subject : Re: USE_LIBXSLT in MSVC builds Previous :From : Tom LaneDate : 2010-03-02 16:23:18Subject : Re: No hash join across partitioned tables?
