Re: No hash join across partitioned tables?

From:	Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To:	Bruce Momjian <bruce(at)momjian(dot)us>
Cc:	Kris Jurka <books(at)ejurka(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject:	Re: No hash join across partitioned tables?
Date:	2010-02-26 00:03:34
Message-ID:	9477.1267142614@sss.pgh.pa.us
Views:	Raw Message | Whole Thread | Download mbox | Resend email
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

In response to

• Re: No hash join across partitioned tables? at 2010-02-25 23:46:33 from Bruce Momjian

Responses

• Re: No hash join across partitioned tables? at 2010-03-02 16:16:51 from Robert Haas

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Karl Schnaitter	2010-02-26 00:11:54	Re: A thought on Index Organized Tables
Previous Message	Tom Lane	2010-02-25 23:59:50	Re: strict version of version_stamp.pl

Browse pgsql-performance by date

	From	Date	Subject
Next Message	Tory M Blue	2010-02-26 06:12:25	bgwriter, checkpoints, curious (seeing delays)
Previous Message	Bruce Momjian	2010-02-25 23:46:33	Re: No hash join across partitioned tables?