Re: [HACKERS] Runtime Partition Pruning

Поиск
Список
Период
Сортировка
Искать
От
Amit Langote
Тема
Re: [HACKERS] Runtime Partition Pruning
Дата
Msg-id
314f8ad6-a99a-607d-340c-ce406b97d4e9@lab.ntt.co.jp
Ответ на
Список
Дерево обсуждения
[HACKERS] Runtime Partition Pruning Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] Runtime Partition Pruning Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] Runtime Partition Pruning Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Runtime Partition Pruning Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] Runtime Partition Pruning amul sul <sulamul@gmail.com>
Re: [HACKERS] Runtime Partition Pruning Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] Runtime Partition Pruning Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] Runtime Partition Pruning Rajkumar Raghuwanshi <rajkumar.raghuwanshi@enterprisedb.com>
Re: [HACKERS] Runtime Partition Pruning Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] Runtime Partition Pruning Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Runtime Partition Pruning Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] Runtime Partition Pruning Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] Runtime Partition Pruning Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] Runtime Partition Pruning Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] Runtime Partition Pruning Jesper Pedersen <jesper.pedersen@redhat.com>
Re: [HACKERS] Runtime Partition Pruning Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] Runtime Partition Pruning Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Runtime Partition Pruning Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Runtime Partition Pruning Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] Runtime Partition Pruning Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Runtime Partition Pruning Andy Fan <zhihui.fan1213@gmail.com>
Re: [HACKERS] Runtime Partition Pruning Andy Fan <zhihui.fan1213@gmail.com>
Re: [HACKERS] Runtime Partition Pruning Andy Fan <zhihui.fan1213@gmail.com>
Re: [HACKERS] Runtime Partition Pruning Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
Re: [HACKERS] Runtime Partition Pruning Amit Langote <amitlangote09@gmail.com>
Re: [HACKERS] Runtime Partition Pruning Andy Fan <zhihui.fan1213@gmail.com>
Re: [HACKERS] Runtime Partition Pruning Andy Fan <zhihui.fan1213@gmail.com>
Re: [HACKERS] Runtime Partition Pruning Ashutosh Bapat <ashutosh.bapat.oss@gmail.com>
Re: [HACKERS] Runtime Partition Pruning Andy Fan <zhihui.fan1213@gmail.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] Runtime Partition Pruning Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Rajkumar Raghuwanshi <rajkumar.raghuwanshi@enterprisedb.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Jesper Pedersen <jesper.pedersen@redhat.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Jesper Pedersen <jesper.pedersen@redhat.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] Runtime Partition Pruning Jesper Pedersen <jesper.pedersen@redhat.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Jesper Pedersen <jesper.pedersen@redhat.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] Runtime Partition Pruning Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Runtime Partition Pruning Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] Runtime Partition Pruning Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Amit Langote <amitlangote09@gmail.com>
Re: [HACKERS] Runtime Partition Pruning Andres Freund <andres@anarazel.de>
Re: [HACKERS] Runtime Partition Pruning Amit Langote <amitlangote09@gmail.com>
Re: [HACKERS] Runtime Partition Pruning Amit Langote <amitlangote09@gmail.com>
Re: [HACKERS] Runtime Partition Pruning Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Andres Freund <andres@anarazel.de>
Re: [HACKERS] Runtime Partition Pruning Amit Langote <amitlangote09@gmail.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] Runtime Partition Pruning Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Runtime Partition Pruning Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] Runtime Partition Pruning Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Runtime Partition Pruning Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] Runtime Partition Pruning Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] Runtime Partition Pruning Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Runtime Partition Pruning Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Runtime Partition Pruning Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Runtime Partition Pruning Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] Runtime Partition Pruning Andres Freund <andres@anarazel.de>
Re: [HACKERS] Runtime Partition Pruning Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Runtime Partition Pruning Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] Runtime Partition Pruning Alvaro Herrera <alvherre@alvh.no-ip.org>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Runtime Partition Pruning Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Runtime Partition Pruning Andres Freund <andres@anarazel.de>
Re: [HACKERS] Runtime Partition Pruning Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Runtime Partition Pruning Andres Freund <andres@anarazel.de>
Re: [HACKERS] Runtime Partition Pruning Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Andres Freund <andres@anarazel.de>
Re: [HACKERS] Runtime Partition Pruning Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Runtime Partition Pruning Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Runtime Partition Pruning Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Jesper Pedersen <jesper.pedersen@redhat.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Jesper Pedersen <jesper.pedersen@redhat.com>
Re: [HACKERS] Runtime Partition Pruning Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Jesper Pedersen <jesper.pedersen@redhat.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Runtime Partition Pruning Simon Riggs <simon@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Amit Langote <amitlangote09@gmail.com>
Re: [HACKERS] Runtime Partition Pruning Rajkumar Raghuwanshi <rajkumar.raghuwanshi@enterprisedb.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] Runtime Partition Pruning David Rowley <david.rowley@2ndquadrant.com>
Re: [HACKERS] Runtime Partition Pruning Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] Runtime Partition Pruning Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] Runtime Partition Pruning Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] Runtime Partition Pruning Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Runtime Partition Pruning Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] Runtime Partition Pruning Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] Runtime Partition Pruning Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] Runtime Partition Pruning Beena Emerson <memissemerson@gmail.com>
Re: [HACKERS] Runtime Partition Pruning Beena Emerson <memissemerson@gmail.com>
On 2018/04/13 14:48, Amit Langote wrote:
> On 2018/04/13 14:38, Amit Langote wrote:
>> About the specific relation_open(.., NoLock) under question, I think there
>> might be a way to address this by opening the tables with the appropriate
>> lock mode in partitioned_rels list in ExecLockNonleafAppendTables
> 
> That may have sounded a bit confusing:
> 
> I meant to say: "by opening the tables in partitioned_rels list with the
> appropriate lock mode in ExecLockNonleafAppendTables"
> 
>> Attached a PoC patch.
>
> There were a couple of unnecessary hunks, which removed in the attached.

Sorry, still a couple more were unnecessary.

Thanks,
Amit
В списке pgsql-hackers по дате отправления
От: Amit Langote
Дата:
От: Kyotaro HORIGUCHI
Дата:
FAQ