Re: Move PinBuffer and UnpinBuffer to atomics

Поиск
Список
Период
Сортировка
Искать
От
Jesper Pedersen
Тема
Re: Move PinBuffer and UnpinBuffer to atomics
Дата
Msg-id
563D11FB.5000209@redhat.com
Ответ на
Список
Дерево обсуждения
Move PinBuffer and UnpinBuffer to atomics YUriy Zhuravlev <u.zhuravlev@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics YUriy Zhuravlev <u.zhuravlev@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics YUriy Zhuravlev <u.zhuravlev@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics YUriy Zhuravlev <u.zhuravlev@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics YUriy Zhuravlev <u.zhuravlev@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics YUriy Zhuravlev <u.zhuravlev@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics YUriy Zhuravlev <u.zhuravlev@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Jesper Pedersen <jesper.pedersen@redhat.com>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Jesper Pedersen <jesper.pedersen@redhat.com>
Re: Move PinBuffer and UnpinBuffer to atomics Jesper Pedersen <jesper.pedersen@redhat.com>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Jesper Pedersen <jesper.pedersen@redhat.com>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Amit Kapila <amit.kapila16@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Amit Kapila <amit.kapila16@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Amit Kapila <amit.kapila16@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Michael Paquier <michael.paquier@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Dilip Kumar <dilipbalaut@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Michael Paquier <michael.paquier@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Dilip Kumar <dilipbalaut@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Merlin Moncure <mmoncure@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Dilip Kumar <dilipbalaut@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Dilip Kumar <dilipbalaut@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Dilip Kumar <dilipbalaut@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Amit Kapila <amit.kapila16@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Dilip Kumar <dilipbalaut@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Dilip Kumar <dilipbalaut@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Dilip Kumar <dilipbalaut@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Dilip Kumar <dilipbalaut@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Dilip Kumar <dilipbalaut@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Robert Haas <robertmhaas@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Dilip Kumar <dilipbalaut@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Dilip Kumar <dilipbalaut@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Dilip Kumar <dilipbalaut@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Dilip Kumar <dilipbalaut@gmail.com>
Document "59.2. Built-in Operator Classes" have a clerical error? osdba <mailtch@163.com>
Re: Document "59.2. Built-in Operator Classes" have a clerical error? "David G. Johnston" <david.g.johnston@gmail.com>
Re: Document "59.2. Built-in Operator Classes" have a clerical error? Bruce Momjian <bruce@momjian.us>
Re: Document "59.2. Built-in Operator Classes" have a clerical error? Bruce Momjian <bruce@momjian.us>
Re:Re: Document "59.2. Built-in Operator Classes" have a clerical error? osdba <mailtch@163.com>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Dilip Kumar <dilipbalaut@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Dilip Kumar <dilipbalaut@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Dilip Kumar <dilipbalaut@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Robert Haas <robertmhaas@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Tom Lane <tgl@sss.pgh.pa.us>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Tom Lane <tgl@sss.pgh.pa.us>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Dilip Kumar <dilipbalaut@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Robert Haas <robertmhaas@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Dilip Kumar <dilipbalaut@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Dilip Kumar <dilipbalaut@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Amit Kapila <amit.kapila16@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Dilip Kumar <dilipbalaut@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Dilip Kumar <dilipbalaut@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Amit Kapila <amit.kapila16@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Robert Haas <robertmhaas@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Robert Haas <robertmhaas@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Amit Kapila <amit.kapila16@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Dilip Kumar <dilipbalaut@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Robert Haas <robertmhaas@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Tom Lane <tgl@sss.pgh.pa.us>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Amit Kapila <amit.kapila16@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Amit Kapila <amit.kapila16@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Amit Kapila <amit.kapila16@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Amit Kapila <amit.kapila16@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Amit Kapila <amit.kapila16@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Amit Kapila <amit.kapila16@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Amit Kapila <amit.kapila16@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Amit Kapila <amit.kapila16@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Amit Kapila <amit.kapila16@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Amit Kapila <amit.kapila16@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Amit Kapila <amit.kapila16@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Move PinBuffer and UnpinBuffer to atomics Merlin Moncure <mmoncure@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics Andres Freund <andres@anarazel.de>
Re: Move PinBuffer and UnpinBuffer to atomics Merlin Moncure <mmoncure@gmail.com>
Re: Move PinBuffer and UnpinBuffer to atomics David Rowley <david.rowley@2ndquadrant.com>
Re: Move PinBuffer and UnpinBuffer to atomics YUriy Zhuravlev <u.zhuravlev@postgrespro.ru>
Hi,

On 11/06/2015 03:38 PM, Andres Freund wrote:
>> While I saw an improvement for the 'synchronous_commit = on' case -
>> there is a small regression for 'off', using -M prepared + Unix Domain
>> Socket. If that is something that should be considered right now.
>
> What tests where you running, in which order? I presume it's a read/write pgbench? What scale, shared buffers?
>

Scale is 3000, and shared buffer is 64Gb, effective is 160Gb.

Order was master/off -> master/on -> pinunpin/off -> pinunpin/on.

> I right now can't see any reason sc on/off should be relevant for the patch. Could it be an artifact of the order you ran tests in?
>

I was puzzled too, hence the post.

> Did you initdb between tests? Pgbench -i? Restart the database?

I didn't initdb / pgbench -i between the tests, so that it is likely it.

I'll redo.

Best regards, Jesper




В списке pgsql-hackers по дате отправления
От: Fabien COELHO
Дата:
От: Robert Haas
Дата:
FAQ