Re: Parallel bitmap heap scan

Поиск
Список
Период
Сортировка
Искать
От
Amit Kapila
Тема
Re: Parallel bitmap heap scan
Дата
Msg-id
CAA4eK1L5oKiTqNqi7LH4yAxiqdyL3GYF5+rttCpnqNHL-nVywQ@mail.gmail.com
Ответ на
Список
Дерево обсуждения
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
Дата:
От: Michael Paquier
Дата:
FAQ