Re: No hash join across partitioned tables?
From:
Bruce Momjian <bruce(at)momjian(dot)us>
To:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc:
Robert Haas <robertmhaas(at)gmail(dot)com>, Kris Jurka <books(at)ejurka(dot)com>,
pgsql-performance(at)postgresql(dot)org
Subject:
Re: No hash join across partitioned tables?
Date:
2010-07-02 20:53:44
Message-ID:
201007022053.o62Kri520462@momjian.us (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
Tom Lane wrote:
> Bruce Momjian <bruce(at)momjian(dot)us> writes:
> > Tom Lane wrote:
> >> I would have liked to get to this for 9.0 but I feel it's a bit late
> >> now.
>
> > What do we want to do about the above issue?
>
> TODO item.
Added to TODO:
Have autoanalyze of parent tables occur when child tables are modified
* http://archives.postgresql.org/message-id/AANLkTinx8lLTEKWcyEQ1rxVz6WMJVKNezfXW5TKnNAU6(at)mail(dot)gmail(dot)com
I am surprised there is no documentation update requirement for this.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ None of us is going to be here forever. +
In response to
Responses
pgsql-performance by date
Next :From: Tom LaneDate: 2010-07-02 20:58:45Subject : Re: No hash join across partitioned tables? Previous :From : Rajesh Kumar MallahDate : 2010-07-02 19:53:03Subject : Re: Extremely high CPU usage when building tables
pgsql-hackers by date
Next :From: Tom LaneDate: 2010-07-02 20:58:45Subject : Re: No hash join across partitioned tables? Previous :From : Tom LaneDate : 2010-07-02 20:52:08Subject : Re: Keepalive for max_standby_delay
