From:
Robert Haas <robertmhaas(at)gmail(dot)com>
To:
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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:16:51
Message-ID:
603c8f071003020816j77b3ec63wbad0415df003c0f1@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 Thu, Feb 25, 2010 at 7:03 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Bruce Momjian <bruce(at)momjian(dot)us> writes:
>> Did this get addressed?
>
> 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.
...Robert
In response to
Responses
pgsql-performance by date
Next :From: Robert HaasDate: 2010-03-02 16:21:15
Subject : Re: GiST index performance
Previous :From : Pierre CDate : 2010-03-02 08:36:48
Subject : Re: SSD + RAID
pgsql-hackers by date
Next :From: Tom LaneDate: 2010-03-02 16:21:28
Subject : Re: USE_LIBXSLT in MSVC builds
Previous :From : Andrew DunstanDate : 2010-03-02 16:00:27
Subject : Re: USE_LIBXSLT in MSVC builds