Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables

Поиск
Список
Период
Сортировка
Искать
От
Ashutosh Bapat
Тема
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables
Дата
Msg-id
CAFjFpRdujTaE+qvQN1m_2EQactnY8sEcxLRzwTOWjHpDHSd=vg@mail.gmail.com
Ответ на
Список
Дерево обсуждения
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Thomas Munro <thomas.munro@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively) partitioned tables Antonin Houska <ah@cybertec.at>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively) partitioned tables Antonin Houska <ah@cybertec.at>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Rafia Sabih <rafia.sabih@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Rafia Sabih <rafia.sabih@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Rafia Sabih <rafia.sabih@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Rafia Sabih <rafia.sabih@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Rafia Sabih <rafia.sabih@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Thomas Munro <thomas.munro@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Thomas Munro <thomas.munro@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Thomas Munro <thomas.munro@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Rajkumar Raghuwanshi <rajkumar.raghuwanshi@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Jeevan Chalke <jeevan.chalke@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Amit Khandekar <amitdkhan.pg@gmail.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Amit Khandekar <amitdkhan.pg@gmail.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Partition-wise join for join between (declaratively)partitioned tables Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
On Wed, Sep 13, 2017 at 11:29 AM, Amit Langote
 wrote:
> On 2017/09/12 19:56, Ashutosh Bapat wrote:
>> I think the code here expects the original parent_rte and not the one
>> we set around line 1169.
>>
>> This isn't a bug right now, since both the parent_rte s have same
>> content. But I am not sure if that will remain to be so. Here's patch
>> to fix the thinko.
>
> Instead of the new bool is_parent_partitioned, why not move the code to
> set partitioned_rels to the block where you're now setting
> is_parent_partitioned.
>
> Also, since we know this isn't a bug at the moment but will turn into one
> once we have step-wise expansion, why not include this fix in that patch
> itself?

It won't turn into a bug with step-wise expansion since every
parent_rte will have RELKIND_PARTITIONED_TABLE for a partitioned top
parent, which is used to extract the partitioned_rels. But I guess,
it's better to fix the thinko in step-wise expansion since parent_rte
itself changes.
-- 
Best Wishes,
Ashutosh Bapat
EnterpriseDB Corporation
The Postgres Database Company


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
В списке pgsql-hackers по дате отправления
От: Ashutosh Bapat
Дата:
От: Ashutosh Bapat
Дата:
FAQ