Re: Parallel bitmap heap scan
От
Robert Haas
Тема
Re: Parallel bitmap heap scan
Дата
Msg-id
CA+TgmoYpcuGz-0RA4Jz1ifcJ6J4z5ED+Dh9Fuc5AuYF26f1_dA@mail.gmail.com
Ответ на
Re: Parallel bitmap heap scan (Dilip Kumar)
Список
Дерево обсуждения
Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: Parallel bitmap heap scan Andres Freund <andres@anarazel.de>
Re: Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: Parallel bitmap heap scan Robert Haas <robertmhaas@gmail.com>
Re: Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: Parallel bitmap heap scan Andres Freund <andres@anarazel.de>
Re: Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: Parallel bitmap heap scan Robert Haas <robertmhaas@gmail.com>
Re: Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: Parallel bitmap heap scan Robert Haas <robertmhaas@gmail.com>
Re: Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: Parallel bitmap heap scan Thomas Munro <thomas.munro@enterprisedb.com>
Re: Parallel bitmap heap scan Amit Kapila <amit.kapila16@gmail.com>
Re: Parallel bitmap heap scan Thomas Munro <thomas.munro@enterprisedb.com>
Re: Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: Parallel bitmap heap scan Amit Kapila <amit.kapila16@gmail.com>
Re: Parallel bitmap heap scan Amit Khandekar <amitdkhan.pg@gmail.com>
Re: Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Amit Khandekar <amitdkhan.pg@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan tushar <tushar.ahuja@enterprisedb.com>
Re: [HACKERS] Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan tushar <tushar.ahuja@enterprisedb.com>
Re: [HACKERS] Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan tushar <tushar.ahuja@enterprisedb.com>
Re: [HACKERS] Parallel bitmap heap scan tushar <tushar.ahuja@enterprisedb.com>
Re: [HACKERS] Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan tushar <tushar.ahuja@enterprisedb.com>
Re: [HACKERS] Parallel bitmap heap scan Rafia Sabih <rafia.sabih@enterprisedb.com>
Re: [HACKERS] Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Haribabu Kommi <kommi.haribabu@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Haribabu Kommi <kommi.haribabu@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Haribabu Kommi <kommi.haribabu@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Thomas Munro <thomas.munro@enterprisedb.com>
Re: [HACKERS] Parallel bitmap heap scan Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Parallel bitmap heap scan Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Parallel bitmap heap scan Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Jeff Janes <jeff.janes@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Parallel bitmap heap scan Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Parallel bitmap heap scan Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Parallel bitmap heap scan Robert Haas <robertmhaas@gmail.com>
Re: Parallel bitmap heap scan Rafia Sabih <rafia.sabih@enterprisedb.com>
Re: Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: Parallel bitmap heap scan Robert Haas <robertmhaas@gmail.com>
Re: Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Andres Freund <andres@anarazel.de>
Re: [HACKERS] Parallel bitmap heap scan Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Andres Freund <andres@anarazel.de>
Re: [HACKERS] Parallel bitmap heap scan Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Dilip Kumar <dilipbalaut@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Jeff Janes <jeff.janes@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan Andres Freund <andres@anarazel.de>
Re: [HACKERS] Parallel bitmap heap scan Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Parallel bitmap heap scan tushar <tushar.ahuja@enterprisedb.com>
On Sat, Nov 26, 2016 at 7:40 AM, Dilip Kumar wrote: > IMHO, barrier is used when multiple worker are doing some work > together in phase1, and before moving to next phase all have to > complete phase1, so we put barrier, so that before starting next phase > all cross the barrier. > > But here case is different, only one worker need to finish the phase1, > and as soon as it's over all can start phase2. But we don't have > requirement that all worker should cross certain barrier. In this case > even though some worker did not start, other worker can do their work. I think the Barrier stuff has a process for choosing one worker to conduct a particular phase. So it seems like if the Barrier API is well-designed, you should be able to use it to decide who will conduct the index scan, and then when that's done everyone can proceed to scanning the heap. If that can't work for some reason, Thomas should probably adjust his API so it does. He's presenting that as a generally-useful primitive... -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
В списке pgsql-hackers по дате отправления
От: Jim Nasby
Дата: