Re: Patch: fix lock contention for HASHHDR.mutex
От
Aleksander Alekseev
Тема
Re: Patch: fix lock contention for HASHHDR.mutex
Дата
Msg-id
20151218171933.500845f6@fujitsu
Ответ на
Re: Patch: fix lock contention for HASHHDR.mutex (Teodor Sigaev)
Список
Дерево обсуждения
Patch: fix lock contention for HASHHDR.mutex Aleksander Alekseev <a.alekseev@postgrespro.ru>
Re: Patch: fix lock contention for HASHHDR.mutex Andres Freund <andres@anarazel.de>
Re: Patch: fix lock contention for HASHHDR.mutex Robert Haas <robertmhaas@gmail.com>
Re: Patch: fix lock contention for HASHHDR.mutex Andres Freund <andres@anarazel.de>
Re: Patch: fix lock contention for HASHHDR.mutex Aleksander Alekseev <a.alekseev@postgrespro.ru>
Re: Patch: fix lock contention for HASHHDR.mutex Robert Haas <robertmhaas@gmail.com>
Re: Patch: fix lock contention for HASHHDR.mutex Aleksander Alekseev <a.alekseev@postgrespro.ru>
Re: Patch: fix lock contention for HASHHDR.mutex Aleksander Alekseev <a.alekseev@postgrespro.ru>
Re: Patch: fix lock contention for HASHHDR.mutex Andres Freund <andres@anarazel.de>
Re: Patch: fix lock contention for HASHHDR.mutex Aleksander Alekseev <a.alekseev@postgrespro.ru>
Re: Patch: fix lock contention for HASHHDR.mutex Teodor Sigaev <teodor@sigaev.ru>
Re: Patch: fix lock contention for HASHHDR.mutex Aleksander Alekseev <a.alekseev@postgrespro.ru>
Re: Patch: fix lock contention for HASHHDR.mutex Robert Haas <robertmhaas@gmail.com>
Re: Patch: fix lock contention for HASHHDR.mutex Aleksander Alekseev <a.alekseev@postgrespro.ru>
Re: Patch: fix lock contention for HASHHDR.mutex Robert Haas <robertmhaas@gmail.com>
Re: Patch: fix lock contention for HASHHDR.mutex Aleksander Alekseev <a.alekseev@postgrespro.ru>
Re: Patch: fix lock contention for HASHHDR.mutex Aleksander Alekseev <a.alekseev@postgrespro.ru>
Re: Patch: fix lock contention for HASHHDR.mutex Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Patch: fix lock contention for HASHHDR.mutex Andres Freund <andres@anarazel.de>
Re: Patch: fix lock contention for HASHHDR.mutex Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Patch: fix lock contention for HASHHDR.mutex Aleksander Alekseev <a.alekseev@postgrespro.ru>
Re: Patch: fix lock contention for HASHHDR.mutex Oleg Bartunov <obartunov@gmail.com>
--enable-depend by default (was Re: Patch: fix lock contention for HASHHDR.mutex) Tom Lane <tgl@sss.pgh.pa.us>
Re: --enable-depend by default (was Re: Patch: fix lock
contention for HASHHDR.mutex) Andres Freund <andres@anarazel.de>
Re: --enable-depend by default (was Re: Patch: fix lock contention
for HASHHDR.mutex) Greg Stark <stark@mit.edu>
Re: --enable-depend by default (was Re: Patch: fix lock contention for HASHHDR.mutex) Tom Lane <tgl@sss.pgh.pa.us>
Re: --enable-depend by default (was Re: Patch: fix lock
contention for HASHHDR.mutex) Andres Freund <andres@anarazel.de>
Re: Patch: fix lock contention for HASHHDR.mutex Fabrízio de Royes Mello <fabriziomello@gmail.com>
Re: Patch: fix lock contention for HASHHDR.mutex Aleksander Alekseev <a.alekseev@postgrespro.ru>
Re: Patch: fix lock contention for HASHHDR.mutex Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Patch: fix lock contention for HASHHDR.mutex Aleksander Alekseev <a.alekseev@postgrespro.ru>
Re: Patch: fix lock contention for HASHHDR.mutex Dilip Kumar <dilipbalaut@gmail.com>
Re: Patch: fix lock contention for HASHHDR.mutex Aleksander Alekseev <a.alekseev@postgrespro.ru>
Re: Patch: fix lock contention for HASHHDR.mutex Dilip Kumar <dilipbalaut@gmail.com>
Re: Patch: fix lock contention for HASHHDR.mutex Aleksander Alekseev <a.alekseev@postgrespro.ru>
Re: Patch: fix lock contention for HASHHDR.mutex Dilip Kumar <dilipbalaut@gmail.com>
Re: Patch: fix lock contention for HASHHDR.mutex Andres Freund <andres@anarazel.de>
Re: Patch: fix lock contention for HASHHDR.mutex Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Patch: fix lock contention for HASHHDR.mutex Anastasia Lubennikova <a.lubennikova@postgrespro.ru>
Re: Patch: fix lock contention for HASHHDR.mutex Aleksander Alekseev <a.alekseev@postgrespro.ru>
Re: Patch: fix lock contention for HASHHDR.mutex Anastasia Lubennikova <a.lubennikova@postgrespro.ru>
Re: Patch: fix lock contention for HASHHDR.mutex Aleksander Alekseev <a.alekseev@postgrespro.ru>
Re: Patch: fix lock contention for HASHHDR.mutex Robert Haas <robertmhaas@gmail.com>
Re: Patch: fix lock contention for HASHHDR.mutex Aleksander Alekseev <a.alekseev@postgrespro.ru>
Re: Patch: fix lock contention for HASHHDR.mutex Robert Haas <robertmhaas@gmail.com>
Re: Patch: fix lock contention for HASHHDR.mutex Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Patch: fix lock contention for HASHHDR.mutex Aleksander Alekseev <a.alekseev@postgrespro.ru>
Re: Patch: fix lock contention for HASHHDR.mutex Robert Haas <robertmhaas@gmail.com>
Re: Patch: fix lock contention for HASHHDR.mutex Aleksander Alekseev <a.alekseev@postgrespro.ru>
Re: Patch: fix lock contention for HASHHDR.mutex Robert Haas <robertmhaas@gmail.com>
Re: Patch: fix lock contention for HASHHDR.mutex Robert Haas <robertmhaas@gmail.com>
Re: Patch: fix lock contention for HASHHDR.mutex Aleksander Alekseev <a.alekseev@postgrespro.ru>
Re: Patch: fix lock contention for HASHHDR.mutex Amit Kapila <amit.kapila16@gmail.com>
Re: Patch: fix lock contention for HASHHDR.mutex Aleksander Alekseev <a.alekseev@postgrespro.ru>
Re: Patch: fix lock contention for HASHHDR.mutex Robert Haas <robertmhaas@gmail.com>
Re: Patch: fix lock contention for HASHHDR.mutex Amit Kapila <amit.kapila16@gmail.com>
Re: Patch: fix lock contention for HASHHDR.mutex Robert Haas <robertmhaas@gmail.com>
Re: Patch: fix lock contention for HASHHDR.mutex Amit Kapila <amit.kapila16@gmail.com>
Re: Patch: fix lock contention for HASHHDR.mutex Robert Haas <robertmhaas@gmail.com>
Re: Patch: fix lock contention for HASHHDR.mutex Amit Kapila <amit.kapila16@gmail.com>
Re: Patch: fix lock contention for HASHHDR.mutex Aleksander Alekseev <a.alekseev@postgrespro.ru>
Re: Patch: fix lock contention for HASHHDR.mutex Robert Haas <robertmhaas@gmail.com>
Re: Patch: fix lock contention for HASHHDR.mutex Aleksander Alekseev <a.alekseev@postgrespro.ru>
Re: Patch: fix lock contention for HASHHDR.mutex Robert Haas <robertmhaas@gmail.com>
Re: Patch: fix lock contention for HASHHDR.mutex Aleksander Alekseev <a.alekseev@postgrespro.ru>
Re: Patch: fix lock contention for HASHHDR.mutex Amit Kapila <amit.kapila16@gmail.com>
Re: Patch: fix lock contention for HASHHDR.mutex Aleksander Alekseev <a.alekseev@postgrespro.ru>
Re: Patch: fix lock contention for HASHHDR.mutex Amit Kapila <amit.kapila16@gmail.com>
Re: Patch: fix lock contention for HASHHDR.mutex Robert Haas <robertmhaas@gmail.com>
Re: Patch: fix lock contention for HASHHDR.mutex Amit Kapila <amit.kapila16@gmail.com>
Re: Patch: fix lock contention for HASHHDR.mutex Aleksander Alekseev <a.alekseev@postgrespro.ru>
Re: Patch: fix lock contention for HASHHDR.mutex Amit Kapila <amit.kapila16@gmail.com>
Re: Patch: fix lock contention for HASHHDR.mutex Aleksander Alekseev <a.alekseev@postgrespro.ru>
Re: Patch: fix lock contention for HASHHDR.mutex Amit Kapila <amit.kapila16@gmail.com>
Re: Patch: fix lock contention for HASHHDR.mutex Tom Lane <tgl@sss.pgh.pa.us>
Re: Patch: fix lock contention for HASHHDR.mutex Aleksander Alekseev <a.alekseev@postgrespro.ru>
Re: Patch: fix lock contention for HASHHDR.mutex Aleksander Alekseev <a.alekseev@postgrespro.ru>
Re: Patch: fix lock contention for HASHHDR.mutex Simon Riggs <simon@2ndQuadrant.com>
Re: Patch: fix lock contention for HASHHDR.mutex Aleksander Alekseev <a.alekseev@postgrespro.ru>
> Could we split one freelist in hash to NUM_LOCK_PARTITIONS freelists? > Each partition will have its own freelist and if freelist is empty > then partition should search an entry in freelists of other > partitions. To prevent concurrent access it's needed to add one > LWLock to hash, each partition should lock LWlock in share mode to > work with its own freelist and exclusive to work with other freelists. > > Actually, I'd like to improve all partitioned hashes instead of > improve only one case. It seems to be a most promising direction of research for now. I will send a patch and benchmark results soon.
В списке pgsql-hackers по дате отправления