Re: Speedup twophase transactions

Поиск
Список
Период
Сортировка
Искать
От
Stas Kelvich
Тема
Re: Speedup twophase transactions
Дата
Msg-id
50E7F508-1C04-4BCC-A6E7-F284C6CB7F26@postgrespro.ru
Ответ на
Список
Дерево обсуждения
Speedup twophase transactions Stas Kelvich <s.kelvich@postgrespro.ru>
Re: Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: Speedup twophase transactions Stas Kelvich <s.kelvich@postgrespro.ru>
Re: Speedup twophase transactions Kevin Grittner <kgrittn@gmail.com>
Re: Speedup twophase transactions Stas Kelvich <s.kelvich@postgrespro.ru>
Re: Speedup twophase transactions Jeff Janes <jeff.janes@gmail.com>
Re: Speedup twophase transactions Simon Riggs <simon@2ndQuadrant.com>
Re: Speedup twophase transactions Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Speedup twophase transactions Stas Kelvich <s.kelvich@postgrespro.ru>
Re: Speedup twophase transactions Simon Riggs <simon@2ndQuadrant.com>
Re: Speedup twophase transactions Simon Riggs <simon@2ndQuadrant.com>
Re: Speedup twophase transactions Andres Freund <andres@anarazel.de>
Re: Speedup twophase transactions Andres Freund <andres@anarazel.de>
Re: Speedup twophase transactions Simon Riggs <simon@2ndQuadrant.com>
Re: Speedup twophase transactions Simon Riggs <simon@2ndQuadrant.com>
Re: Speedup twophase transactions Andres Freund <andres@anarazel.de>
Re: Speedup twophase transactions Simon Riggs <simon@2ndQuadrant.com>
Re: Speedup twophase transactions Andres Freund <andres@anarazel.de>
Re: Speedup twophase transactions Simon Riggs <simon@2ndQuadrant.com>
Re: Speedup twophase transactions Stas Kelvich <s.kelvich@postgrespro.ru>
Re: Speedup twophase transactions Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Speedup twophase transactions Stas Kelvich <s.kelvich@postgrespro.ru>
Re: Speedup twophase transactions David Steele <david@pgmasters.net>
Re: Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: Speedup twophase transactions Jesper Pedersen <jesper.pedersen@redhat.com>
Re: Speedup twophase transactions Stas Kelvich <s.kelvich@postgrespro.ru>
Re: Speedup twophase transactions Jesper Pedersen <jesper.pedersen@redhat.com>
Re: Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: Speedup twophase transactions David Steele <david@pgmasters.net>
Re: Speedup twophase transactions Stas Kelvich <s.kelvich@postgrespro.ru>
Re: Speedup twophase transactions Jesper Pedersen <jesper.pedersen@redhat.com>
Re: Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: Speedup twophase transactions Stas Kelvich <s.kelvich@postgrespro.ru>
Re: Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: Speedup twophase transactions Stas Kelvich <s.kelvich@postgrespro.ru>
Re: Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: Speedup twophase transactions Jesper Pedersen <jesper.pedersen@redhat.com>
Re: Speedup twophase transactions Robert Haas <robertmhaas@gmail.com>
Re: Speedup twophase transactions Jesper Pedersen <jesper.pedersen@redhat.com>
Re: Speedup twophase transactions Noah Misch <noah@leadboat.com>
Re: Speedup twophase transactions Stas Kelvich <s.kelvich@postgrespro.ru>
Re: Speedup twophase transactions Stas Kelvich <s.kelvich@postgrespro.ru>
Re: Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: Speedup twophase transactions Stas Kelvich <s.kelvich@postgrespro.ru>
Re: Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: Speedup twophase transactions Stas Kelvich <s.kelvich@postgrespro.ru>
Re: Speedup twophase transactions Jesper Pedersen <jesper.pedersen@redhat.com>
Re: Speedup twophase transactions Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: Speedup twophase transactions Simon Riggs <simon@2ndquadrant.com>
Re: Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: Speedup twophase transactions Stas Kelvich <s.kelvich@postgrespro.ru>
Re: Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: Speedup twophase transactions Stas Kelvich <s.kelvich@postgrespro.ru>
Re: Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: Speedup twophase transactions Stas Kelvich <s.kelvich@postgrespro.ru>
Re: Speedup twophase transactions Stas Kelvich <s.kelvich@postgrespro.ru>
Re: Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: Speedup twophase transactions Stas Kelvich <s.kelvich@postgrespro.ru>
Re: Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: Speedup twophase transactions Stas Kelvich <s.kelvich@postgrespro.ru>
Re: Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] Speedup twophase transactions Stas Kelvich <s.kelvich@postgrespro.ru>
Re: [HACKERS] Speedup twophase transactions Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] Speedup twophase transactions Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] Speedup twophase transactions David Fetter <david@fetter.org>
Re: [HACKERS] Speedup twophase transactions Andres Freund <andres@anarazel.de>
Re: [HACKERS] Speedup twophase transactions Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] Speedup twophase transactions Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] Speedup twophase transactions Stas Kelvich <s.kelvich@postgrespro.ru>
Re: [HACKERS] Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] Speedup twophase transactions Stas Kelvich <s.kelvich@postgrespro.ru>
Re: [HACKERS] Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] Speedup twophase transactions Stas Kelvich <s.kelvich@postgrespro.ru>
Re: [HACKERS] Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] Speedup twophase transactions Stas Kelvich <s.kelvich@postgrespro.ru>
Re: [HACKERS] Speedup twophase transactions Nikhil Sontakke <nikhils@2ndquadrant.com>
Re: [HACKERS] Speedup twophase transactions Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Speedup twophase transactions Nikhil Sontakke <nikhils@2ndquadrant.com>
Re: [HACKERS] Speedup twophase transactions Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] Speedup twophase transactions Stas Kelvich <s.kelvich@postgrespro.ru>
Re: [HACKERS] Speedup twophase transactions Nikhil Sontakke <nikhils@2ndquadrant.com>
Re: [HACKERS] Speedup twophase transactions Nikhil Sontakke <nikhils@2ndquadrant.com>
Re: [HACKERS] Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] Speedup twophase transactions Nikhil Sontakke <nikhils@2ndquadrant.com>
Re: [HACKERS] Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] Speedup twophase transactions Nikhil Sontakke <nikhils@2ndquadrant.com>
Re: [HACKERS] Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] Speedup twophase transactions Stas Kelvich <s.kelvich@postgrespro.ru>
Re: [HACKERS] Speedup twophase transactions Nikhil Sontakke <nikhils@2ndquadrant.com>
Re: [HACKERS] Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] Speedup twophase transactions Nikhil Sontakke <nikhils@2ndquadrant.com>
Re: [HACKERS] Speedup twophase transactions Simon Riggs <simon@2ndquadrant.com>
Re: [HACKERS] Speedup twophase transactions Nikhil Sontakke <nikhils@2ndquadrant.com>
Re: [HACKERS] Speedup twophase transactions Simon Riggs <simon@2ndquadrant.com>
Re: [HACKERS] Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] Speedup twophase transactions Nikhil Sontakke <nikhils@2ndquadrant.com>
Re: [HACKERS] Speedup twophase transactions Nikhil Sontakke <nikhils@2ndquadrant.com>
Re: [HACKERS] Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] Speedup twophase transactions Nikhil Sontakke <nikhils@2ndquadrant.com>
Re: [HACKERS] Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] Speedup twophase transactions Nikhil Sontakke <nikhils@2ndquadrant.com>
Re: [HACKERS] Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] Speedup twophase transactions Nikhil Sontakke <nikhils@2ndquadrant.com>
Re: [HACKERS] Speedup twophase transactions Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] Speedup twophase transactions Nikhil Sontakke <nikhils@2ndquadrant.com>
Re: [HACKERS] Speedup twophase transactions David Steele <david@pgmasters.net>
Re: [HACKERS] Speedup twophase transactions Nikhil Sontakke <nikhils@2ndquadrant.com>
Re: [HACKERS] Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] Speedup twophase transactions Nikhil Sontakke <nikhils@2ndquadrant.com>
Re: [HACKERS] Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] Speedup twophase transactions Nikhil Sontakke <nikhils@2ndquadrant.com>
Re: [HACKERS] Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] Speedup twophase transactions Nikhil Sontakke <nikhils@2ndquadrant.com>
Re: [HACKERS] Speedup twophase transactions Nikhil Sontakke <nikhils@2ndquadrant.com>
Re: [HACKERS] Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] Speedup twophase transactions Nikhil Sontakke <nikhils@2ndquadrant.com>
Re: [HACKERS] Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: Speedup twophase transactions Nikhil Sontakke <nikhils@2ndquadrant.com>
Re: Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: Speedup twophase transactions Nikhil Sontakke <nikhils@2ndquadrant.com>
Re: Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: Speedup twophase transactions Nikhil Sontakke <nikhils@2ndquadrant.com>
Re: Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: Speedup twophase transactions Nikhil Sontakke <nikhils@2ndquadrant.com>
Re: [HACKERS] Speedup twophase transactions Nikhil Sontakke <nikhils@2ndquadrant.com>
Re: Speedup twophase transactions Simon Riggs <simon@2ndquadrant.com>
Re: Speedup twophase transactions Simon Riggs <simon@2ndquadrant.com>
Re: Speedup twophase transactions Simon Riggs <simon@2ndQuadrant.com>
Re: Speedup twophase transactions Stas Kelvich <s.kelvich@postgrespro.ru>
Re: Speedup twophase transactions Robert Haas <robertmhaas@gmail.com>
Re: Speedup twophase transactions Jesper Pedersen <jesper.pedersen@redhat.com>
Re: Speedup twophase transactions Stas Kelvich <s.kelvich@postgrespro.ru>
Re: Speedup twophase transactions Stas Kelvich <s.kelvich@postgrespro.ru>
Re: Speedup twophase transactions Simon Riggs <simon@2ndQuadrant.com>
Re: Speedup twophase transactions Stas Kelvich <s.kelvich@postgrespro.ru>
Re: Speedup twophase transactions Simon Riggs <simon@2ndQuadrant.com>
Re: Speedup twophase transactions Simon Riggs <simon@2ndQuadrant.com>
Re: Speedup twophase transactions Andres Freund <andres@anarazel.de>
Re: Speedup twophase transactions Simon Riggs <simon@2ndQuadrant.com>
Re: Speedup twophase transactions Andres Freund <andres@anarazel.de>
Re: Speedup twophase transactions Simon Riggs <simon@2ndQuadrant.com>
Re: Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: Speedup twophase transactions Simon Riggs <simon@2ndQuadrant.com>
Re: Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: Speedup twophase transactions Simon Riggs <simon@2ndQuadrant.com>
Re: Speedup twophase transactions Michael Paquier <michael.paquier@gmail.com>
Re: Speedup twophase transactions Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Speedup twophase transactions Stas Kelvich <s.kelvich@postgrespro.ru>
Re: Speedup twophase transactions Simon Riggs <simon@2ndQuadrant.com>
Re: Speedup twophase transactions Jesper Pedersen <jesper.pedersen@redhat.com>
Re: Speedup twophase transactions Simon Riggs <simon@2ndQuadrant.com>
Re: Speedup twophase transactions Jesper Pedersen <jesper.pedersen@redhat.com>
Re: Speedup twophase transactions Stas Kelvich <s.kelvich@postgrespro.ru>
Re: Speedup twophase transactions Jesper Pedersen <jesper.pedersen@redhat.com>
Re: Speedup twophase transactions Simon Riggs <simon@2ndQuadrant.com>
Thanks a lot for your edits, now that patch is much more cleaner.

> Your comments say
> 
>   "In case of crash replay will move data from xlog to files, if that hasn't happened before."
> 
> but I don't see that in code. Can you show me where that happens? 

xact.c calls RecreateTwoPhaseFile in xact_redo() function (xact.c:5596)

> On 09 Jan 2016, at 18:29, Simon Riggs  wrote:
> 
> Hmm, I was just preparing this for commit.
> 
> Please have a look at my mild edits and extended comments. 


One concern that come into my mind while reading updated
patch is about creating extra bool field in GlobalTransactionData structure. While this improves readability, it
also increases size of that structure and that size have impact on performance on systems with many cores
(say like 60-80). Probably one byte will not make measurable difference, but I think it is good idea to keep
GXact as small as possible. As far as I understand the same logic was behind split of 
PGPROC to PGPROC+PGXACT in 9.2 (comment in proc.h:166)

Stas Kelvich
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company


В списке pgsql-hackers по дате отправления
От: Tomas Vondra
Дата:
От: Michael Paquier
Дата:
FAQ