From:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:
Robert Haas <robertmhaas(at)gmail(dot)com>
Cc:
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:23:18
Message-ID:
17546.1267546998@sss.pgh.pa.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
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.
regards, tom lane
In response to
Responses
pgsql-performance by date
Next :From: Robert HaasDate: 2010-03-02 16:23:22Subject : Re: GiST index performancePrevious :From : Robert HaasDate : 2010-03-02 16:21:15Subject : Re: GiST index performance
pgsql-hackers by date
Next :From: Grzegorz JaśkiewiczDate: 2010-03-02 16:27:14Subject : Re: No hash join across partitioned tables?Previous :From : Tom LaneDate : 2010-03-02 16:21:28Subject : Re: USE_LIBXSLT in MSVC builds
