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 по дате отправления
От: Alvaro Herrera
Дата:
От: Reid Thompson
Дата:
FAQ