Re: Parallel bitmap heap scan
От
Amit Kapila
Тема
Re: Parallel bitmap heap scan
Дата
Msg-id
CAA4eK1L5oKiTqNqi7LH4yAxiqdyL3GYF5+rttCpnqNHL-nVywQ@mail.gmail.com
Ответ на
Re: Parallel bitmap heap scan (Thomas Munro)
Список
Дерево обсуждения
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 Mon, Nov 28, 2016 at 8:11 AM, Thomas Munro wrote: > When a new participant arrives here, if it finds that we're still in > the INIT phase, then it enters an election to see if it can build the > bitmap; one lucky participant wins and does that, while any other > participants twiddle their thumbs at the next BarrierWait call. If a > new participant finds that we're already in the BUILDING phase when it > arrives, then it has missed that election and just has to wait for the > building to be completed. Once they all agree that building has > finished, we move onto scanning. If a new arrival finds that we're in > SCANNING phase, then it happily scans and emits tuples. Does that > make sense? > > Not sure exactly how to coordinate rescans yet, but probably with > BarrierWaitSet(&something->barrier, PBS_PHASE_INIT). > Do you think that using barrier's will simplify the patch as compared to using condition variables because in that case, it will make sense to use barriers? -- With Regards, Amit Kapila. EnterpriseDB: http://www.enterprisedb.com
В списке pgsql-hackers по дате отправления
От: Michael Paquier
Дата: