RE: speeding up planning with partitions

Поиск
Список
Период
Сортировка
Искать
От
Imai, Yoshikazu
Тема
RE: speeding up planning with partitions
Дата
Msg-id
0F97FA9ABBDBE54F91744A9B37151A51259637@g01jpexmbkw24
Ответ на
Список
Дерево обсуждения
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>
Hi Amit-san,

On Wed, Jan 17, 2019 at 10:25 AM, Amit Langote wrote:
> Thank you Imai-san for testing.  Sorry it totally slipped my mind to reply to this email.

Thanks for replying and sorry for my late reply. I've been undertaking on-the-job training last week.

> Are you saying that, when using auto mode, all executions of the query
> starting from 7th are slower than the first 5 executions?  That is, the
> latency of creating and using a custom plan increases *after* a generic
> plan is created and discarded on the 6th execution of the query?  If so,
> that is inexplicable to me.

Yes. And it's also inexplicable to me.

I'll check if this fact is really correct by majoring the time of the
first 5 queries before generic plan is created and the other queries
after generic plan is created.

Yoshikazu Imai 

В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
От: Andrew Gierth
Дата:
FAQ