Re: Speedup twophase transactions
От
Jesper Pedersen
Тема
Re: Speedup twophase transactions
Дата
Msg-id
5693F997.4000702@redhat.com
Ответ на
Re: Speedup twophase transactions (Simon Riggs)
Список
Дерево обсуждения
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>
On 01/10/2016 04:15 AM, Simon Riggs wrote: >> 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) > > > I think padding will negate the effects of the additional bool. > > If we want to reduce the size of the array GIDSIZE is currently 200, but XA > says maximum 128 bytes. > > Anybody know why that is set to 200? > Even though GlobalTransactionId and BranchQualifer have a maximum of 64 each, external clients may choose to encode the information, and thereby need more space, https://github.com/pgjdbc/pgjdbc/blob/master/pgjdbc/src/main/java/org/postgresql/xa/RecoveredXid.java#L66-L70 http://docs.oracle.com/javaee/7/api/javax/transaction/xa/Xid.html which in this case adds up to a maximum of 189 characters. Best regards, Jesper
В списке pgsql-hackers по дате отправления