RE: speeding up planning with partitions
От
Imai, Yoshikazu
Тема
RE: speeding up planning with partitions
Дата
Msg-id
0F97FA9ABBDBE54F91744A9B37151A5129E7D2@g01jpexmbkw24
Ответ на
RE: speeding up planning with partitions (Imai, Yoshikazu)
Список
Дерево обсуждения
speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
RE: speeding up planning with partitions "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
RE: speeding up planning with partitions "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
RE: speeding up planning with partitions "Kato, Sho" <kato-sho@jp.fujitsu.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
RE: speeding up planning with partitions "Kato, Sho" <kato-sho@jp.fujitsu.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions David Rowley <david.rowley@2ndquadrant.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions Alvaro Herrera <alvherre@2ndquadrant.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions Jesper Pedersen <jesper.pedersen@redhat.com>
Re: speeding up planning with partitions David Rowley <david.rowley@2ndquadrant.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions Justin Pryzby <pryzby@telsasoft.com>
Re: speeding up planning with partitions David Rowley <david.rowley@2ndquadrant.com>
Re: speeding up planning with partitions Justin Pryzby <pryzby@telsasoft.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
Re: speeding up planning with partitions Alvaro Herrera <alvherre@2ndquadrant.com>
Re: speeding up planning with partitions Amit Langote <amitlangote09@gmail.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions Alvaro Herrera <alvherre@2ndquadrant.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions David Rowley <david.rowley@2ndquadrant.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions Alvaro Herrera <alvherre@2ndquadrant.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
Re: speeding up planning with partitions Alvaro Herrera <alvherre@2ndquadrant.com>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions Jesper Pedersen <jesper.pedersen@redhat.com>
Re: speeding up planning with partitions David Rowley <david.rowley@2ndquadrant.com>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
Re: speeding up planning with partitions David Rowley <david.rowley@2ndquadrant.com>
Re: speeding up planning with partitions David Rowley <david.rowley@2ndquadrant.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions David Rowley <david.rowley@2ndquadrant.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions David Rowley <david.rowley@2ndquadrant.com>
Re: speeding up planning with partitions David Rowley <david.rowley@2ndquadrant.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions David Rowley <david.rowley@2ndquadrant.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions Alvaro Herrera <alvherre@2ndquadrant.com>
Re: speeding up planning with partitions David Rowley <david.rowley@2ndquadrant.com>
Re: speeding up planning with partitions Amit Langote <amitlangote09@gmail.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
RE: speeding up planning with partitions "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
RE: speeding up planning with partitions "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
Re: speeding up planning with partitions David Rowley <david.rowley@2ndquadrant.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions Tom Lane <tgl@sss.pgh.pa.us>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
Re: speeding up planning with partitions Tom Lane <tgl@sss.pgh.pa.us>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions Tom Lane <tgl@sss.pgh.pa.us>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions Tom Lane <tgl@sss.pgh.pa.us>
Re: speeding up planning with partitions Tom Lane <tgl@sss.pgh.pa.us>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions Tom Lane <tgl@sss.pgh.pa.us>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions Justin Pryzby <pryzby@telsasoft.com>
Re: speeding up planning with partitions Amit Langote <amitlangote09@gmail.com>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions Jesper Pedersen <jesper.pedersen@redhat.com>
Re: speeding up planning with partitions Amit Langote <amitlangote09@gmail.com>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
Re: speeding up planning with partitions David Rowley <david.rowley@2ndquadrant.com>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions Jesper Pedersen <jesper.pedersen@redhat.com>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
Re: speeding up planning with partitions Jesper Pedersen <jesper.pedersen@redhat.com>
Re: speeding up planning with partitions Imai Yoshikazu <yoshikazu_i443@live.jp>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions Tom Lane <tgl@sss.pgh.pa.us>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
Re: speeding up planning with partitions Tom Lane <tgl@sss.pgh.pa.us>
Re: speeding up planning with partitions David Rowley <david.rowley@2ndquadrant.com>
Re: speeding up planning with partitions Jesper Pedersen <jesper.pedersen@redhat.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
Re: speeding up planning with partitions Jesper Pedersen <jesper.pedersen@redhat.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
Re: speeding up planning with partitions Robert Haas <robertmhaas@gmail.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
Re: speeding up planning with partitions Jesper Pedersen <jesper.pedersen@redhat.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions Jesper Pedersen <jesper.pedersen@redhat.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions Justin Pryzby <pryzby@telsasoft.com>
Re: speeding up planning with partitions David Rowley <david.rowley@2ndquadrant.com>
Re: speeding up planning with partitions David Rowley <david.rowley@2ndquadrant.com>
Re: speeding up planning with partitions Alvaro Herrera <alvherre@2ndquadrant.com>
Re: speeding up planning with partitions David Rowley <david.rowley@2ndquadrant.com>
Re: speeding up planning with partitions David Rowley <david.rowley@2ndquadrant.com>
Re: speeding up planning with partitions Amit Langote <amitlangote09@gmail.com>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
RE: speeding up planning with partitions "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions David Rowley <david.rowley@2ndquadrant.com>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
RE: speeding up planning with partitions "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
Re: speeding up planning with partitions David Rowley <david.rowley@2ndquadrant.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
RE: speeding up planning with partitions "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
RE: speeding up planning with partitions "Imai, Yoshikazu" <imai.yoshikazu@jp.fujitsu.com>
Re: speeding up planning with partitions David Rowley <david.rowley@2ndquadrant.com>
RE: speeding up planning with partitions "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
RE: speeding up planning with partitions "Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>
Re: speeding up planning with partitions 今井 良一 <yoshikazu_i443@live.jp>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions Thomas Munro <thomas.munro@enterprisedb.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions Dilip Kumar <dilipbalaut@gmail.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions Michael Paquier <michael@paquier.xyz>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions Dilip Kumar <dilipbalaut@gmail.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions Dilip Kumar <dilipbalaut@gmail.com>
Re: speeding up planning with partitions Peter Geoghegan <pg@bowt.ie>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions David Rowley <david.rowley@2ndquadrant.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: speeding up planning with partitions David Rowley <david.rowley@2ndquadrant.com>
Re: speeding up planning with partitions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Amit-san,
I have another little comments about v31-patches.
* We don't need is_first_child in inheritance_planner().
On Fri, Mar 8, 2019 at 9:18 AM, Amit Langote wrote:
> On 2019/03/08 16:16, Imai, Yoshikazu wrote:
> > I attached the diff of modification for v26-0003 patch which also
> contains some refactoring.
> > Please see if it is ok.
>
> I like the is_first_child variable which somewhat improves readability,
> so updated the patch to use it.
I noticed that detecting first child query in inheritance_planner() is already done by "final_rtable == NIL"
/*
* If this is the first non-excluded child, its post-planning rtable
* becomes the initial contents of final_rtable; otherwise, append
* just its modified subquery RTEs to final_rtable.
*/
if (final_rtable == NIL)
So I think we can use that instead of using is_first_child.
--
Yoshikazu Imai
В списке pgsql-hackers по дате отправления