Re: speeding up planning with partitions
От
Tom Lane
Тема
Re: speeding up planning with partitions
Дата
Msg-id
18712.1553698656@sss.pgh.pa.us
Список
Дерево обсуждения
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>
David Rowley writes: > On Wed, 27 Mar 2019 at 18:39, Amit Langote > wrote: >> On 2019/03/27 14:26, David Rowley wrote: >>> Perhaps the way to make this work, at least in the long term is to do >>> in the planner what we did in the executor in d73f4c74dd34. >> Maybe you meant 9ddef36278a9? > Probably. Yeah, there's something to be said for having plancat.c open each table *and store the Relation pointer in the RelOptInfo*, and then close that again at the end of planning rather than immediately. If we can't avoid these retail table_opens without a great deal of pain, that's the direction I'd tend to go in. However it would add some overhead, in the form of a need to traverse the RelOptInfo array an additional time. regards, tom lane
В списке pgsql-hackers по дате отправления