Re: Add 64-bit XIDs into PostgreSQL 15
От
Thom Brown
Тема
Re: Add 64-bit XIDs into PostgreSQL 15
Дата
Msg-id
CAA-aLv66OSmjqebjfjPS2hwm4UYc48iO_kHyALQPV0CWuR85+Q@mail.gmail.com
Ответ на
Re: Add 64-bit XIDs into PostgreSQL 15 (Maxim Orlov)
Список
Дерево обсуждения
Add 64-bit XIDs into PostgreSQL 15 Maxim Orlov <orlovmg@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Stephen Frost <sfrost@snowman.net>
Re: Add 64-bit XIDs into PostgreSQL 15 "Finnerty, Jim" <jfinnert@amazon.com>
Re: Add 64-bit XIDs into PostgreSQL 15 "Finnerty, Jim" <jfinnert@amazon.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Simon Riggs <simon.riggs@enterprisedb.com>
Re: Add 64-bit XIDs into PostgreSQL 15 "Finnerty, Jim" <jfinnert@amazon.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Alexander Korotkov <aekorotkov@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 "Finnerty, Jim" <jfinnert@amazon.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Justin Pryzby <pryzby@telsasoft.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Simon Riggs <simon.riggs@enterprisedb.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Bruce Momjian <bruce@momjian.us>
Re: Add 64-bit XIDs into PostgreSQL 15 Bruce Momjian <bruce@momjian.us>
Re: Add 64-bit XIDs into PostgreSQL 15 Ilya Anfimov <ilan@tzirechnoy.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Pavel Borisov <pashkin.elfe@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Andres Freund <andres@anarazel.de>
Re: Add 64-bit XIDs into PostgreSQL 15 Pavel Borisov <pashkin.elfe@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Aleksander Alekseev <aleksander@timescale.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Andres Freund <andres@anarazel.de>
Re: Add 64-bit XIDs into PostgreSQL 15 Aleksander Alekseev <aleksander@timescale.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Pavel Borisov <pashkin.elfe@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Pavel Borisov <pashkin.elfe@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Maxim Orlov <orlovmg@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Alexander Korotkov <aekorotkov@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Pavel Borisov <pashkin.elfe@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Stephen Frost <sfrost@snowman.net>
Re: Add 64-bit XIDs into PostgreSQL 15 Aleksander Alekseev <aleksander@timescale.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Aleksander Alekseev <aleksander@timescale.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Aleksander Alekseev <aleksander@timescale.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Aleksander Alekseev <aleksander@timescale.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Justin Pryzby <pryzby@telsasoft.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Pavel Borisov <pashkin.elfe@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Maxim Orlov <orlovmg@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Maxim Orlov <orlovmg@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Maxim Orlov <orlovmg@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Maxim Orlov <orlovmg@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Maxim Orlov <orlovmg@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Maxim Orlov <orlovmg@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Pavel Borisov <pashkin.elfe@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Pavel Borisov <pashkin.elfe@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Justin Pryzby <pryzby@telsasoft.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Pavel Borisov <pashkin.elfe@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Maxim Orlov <orlovmg@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Maxim Orlov <orlovmg@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Maxim Orlov <orlovmg@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Maxim Orlov <orlovmg@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Pavel Borisov <pashkin.elfe@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Pavel Borisov <pashkin.elfe@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Justin Pryzby <pryzby@telsasoft.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Pavel Borisov <pashkin.elfe@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Aleksander Alekseev <aleksander@timescale.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Pavel Borisov <pashkin.elfe@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Dilip Kumar <dilipbalaut@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Dilip Kumar <dilipbalaut@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Maxim Orlov <orlovmg@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Maxim Orlov <orlovmg@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Zhang Mingli <zmlpostgres@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Zhang Mingli <zmlpostgres@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Justin Pryzby <pryzby@telsasoft.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Zhang Mingli <zmlpostgres@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Maxim Orlov <orlovmg@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Michael Paquier <michael@paquier.xyz>
Re: Add 64-bit XIDs into PostgreSQL 15 Maxim Orlov <orlovmg@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Simon Riggs <simon.riggs@enterprisedb.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Zhang Mingli <zmlpostgres@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Maxim Orlov <orlovmg@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Thom Brown <thom@linux.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Maxim Orlov <orlovmg@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Tom Lane <tgl@sss.pgh.pa.us>
Re: Add 64-bit XIDs into PostgreSQL 15 Andres Freund <andres@anarazel.de>
Re: Add 64-bit XIDs into PostgreSQL 15 Tom Lane <tgl@sss.pgh.pa.us>
Re: Add 64-bit XIDs into PostgreSQL 15 Andres Freund <andres@anarazel.de>
Re: Add 64-bit XIDs into PostgreSQL 15 Aleksander Alekseev <aleksander@timescale.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Aleksander Alekseev <aleksander@timescale.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Chris Travers <chris.travers@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Peter Geoghegan <pg@bowt.ie>
Re: Add 64-bit XIDs into PostgreSQL 15 Aleksander Alekseev <aleksander@timescale.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Chris Travers <chris@orioledata.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Robert Haas <robertmhaas@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Chris Travers <chris@orioledata.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Robert Haas <robertmhaas@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Bruce Momjian <bruce@momjian.us>
Re: Add 64-bit XIDs into PostgreSQL 15 Chris Travers <chris@orioledata.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Robert Haas <robertmhaas@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Peter Geoghegan <pg@bowt.ie>
Re: Add 64-bit XIDs into PostgreSQL 15 Pavel Borisov <pashkin.elfe@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Maxim Orlov <orlovmg@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Maxim Orlov <orlovmg@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Aleksander Alekseev <aleksander@timescale.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Daniel Gustafsson <daniel@yesql.se>
Re: Add 64-bit XIDs into PostgreSQL 15 Aleksander Alekseev <aleksander@timescale.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Maxim Orlov <orlovmg@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 wenhui qiu <qiuwenhuifx@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Pavel Borisov <pashkin.elfe@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 wenhui qiu <qiuwenhuifx@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Shubham Khanna <khannashubham1197@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Aleksander Alekseev <aleksander@timescale.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Aleksander Alekseev <aleksander@timescale.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Aleksander Alekseev <aleksander@timescale.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Peter Eisentraut <peter@eisentraut.org>
Re: Add 64-bit XIDs into PostgreSQL 15 Heikki Linnakangas <hlinnaka@iki.fi>
Re: Add 64-bit XIDs into PostgreSQL 15 Peter Eisentraut <peter@eisentraut.org>
Re: Add 64-bit XIDs into PostgreSQL 15 wenhui qiu <qiuwenhuifx@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Chris Travers <chris.travers@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 adherent postgres <adherent_postgres@hotmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Peter Geoghegan <pg@bowt.ie>
Re: Add 64-bit XIDs into PostgreSQL 15 Robert Haas <robertmhaas@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Peter Geoghegan <pg@bowt.ie>
Re: Add 64-bit XIDs into PostgreSQL 15 Robert Haas <robertmhaas@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Peter Geoghegan <pg@bowt.ie>
Re: Add 64-bit XIDs into PostgreSQL 15 Greg Stark <stark@mit.edu>
Re: Add 64-bit XIDs into PostgreSQL 15 Bruce Momjian <bruce@momjian.us>
Re: Add 64-bit XIDs into PostgreSQL 15 Peter Geoghegan <pg@bowt.ie>
Re: Add 64-bit XIDs into PostgreSQL 15 Chris Travers <chris@orioledata.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Bruce Momjian <bruce@momjian.us>
Re: Add 64-bit XIDs into PostgreSQL 15 Jan Wieck <jan@wi3ck.info>
Re: Add 64-bit XIDs into PostgreSQL 15 Maxim Orlov <orlovmg@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Pavel Borisov <pashkin.elfe@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Chris Travers <chris@orioledata.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Aleksander Alekseev <aleksander@timescale.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Chris Travers <chris@orioledata.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Aleksander Alekseev <aleksander@timescale.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Pavel Borisov <pashkin.elfe@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Aleksander Alekseev <aleksander@timescale.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Dilip Kumar <dilipbalaut@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Aleksander Alekseev <aleksander@timescale.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Chris Travers <chris@orioledata.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Aleksander Alekseev <aleksander@timescale.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Michael Banck <michael.banck@credativ.de>
Re: Add 64-bit XIDs into PostgreSQL 15 Aleksander Alekseev <aleksander@timescale.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Maxim Orlov <orlovmg@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Pavel Borisov <pashkin.elfe@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Pavel Borisov <pashkin.elfe@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Maxim Orlov <orlovmg@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Maxim Orlov <orlovmg@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Aleksander Alekseev <aleksander@timescale.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Pavel Borisov <pashkin.elfe@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Maxim Orlov <orlovmg@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Maxim Orlov <orlovmg@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Andres Freund <andres@anarazel.de>
Re: Add 64-bit XIDs into PostgreSQL 15 Pavel Borisov <pashkin.elfe@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Aleksander Alekseev <aleksander@timescale.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Pavel Borisov <pashkin.elfe@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Justin Pryzby <pryzby@telsasoft.com>
Re: Add 64-bit XIDs into PostgreSQL 15 "Finnerty, Jim" <jfinnert@amazon.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Maxim Orlov <orlovmg@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Simon Riggs <simon.riggs@enterprisedb.com>
Re: Add 64-bit XIDs into PostgreSQL 15 "Finnerty, Jim" <jfinnert@amazon.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Pavel Borisov <pashkin.elfe@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Pavel Borisov <pashkin.elfe@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Julien Rouhaud <rjuju123@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Bruce Momjian <bruce@momjian.us>
Re: Add 64-bit XIDs into PostgreSQL 15 Fujii Masao <masao.fujii@oss.nttdata.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Maxim Orlov <orlovmg@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Peter Geoghegan <pg@bowt.ie>
Re: Add 64-bit XIDs into PostgreSQL 15 Robert Haas <robertmhaas@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Corey Huinker <corey.huinker@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Simon Riggs <simon.riggs@enterprisedb.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Fujii Masao <masao.fujii@oss.nttdata.com>
Re: Add 64-bit XIDs into PostgreSQL 15 "Finnerty, Jim" <jfinnert@amazon.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Simon Riggs <simon.riggs@enterprisedb.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Bruce Momjian <bruce@momjian.us>
Re: Add 64-bit XIDs into PostgreSQL 15 Alexander Korotkov <aekorotkov@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Robert Haas <robertmhaas@gmail.com>
Re: Add 64-bit XIDs into PostgreSQL 15 Stephen Frost <sfrost@snowman.net>
On Thu, 3 Nov 2022 at 08:12, Maxim Orlov wrote: > > Hi! > >> I attach an additional V48-0009 patch as they are just comments, apply it if you want to. > > Big thank you for your review. I've applied your addition in the recent patch set below. > > Besides, mentioned above, next changes are made: > - rename HeapTupleCopyBaseFromPage to HeapTupleCopyXidsFromPage, since this old name came from the time when еру "t_xid_base" was stored in tuple, > and not correspond to recent state of the code; > - replace ToastTupleHeader* calls with HeapHeader* with the "is_toast" argument. This reduces diff and make the code more readable; > - put HeapTupleSetZeroXids calls in several places for the sake of redundancy; > - in heap_tuple_would_freeze add case to reset xmax without reading clog; > - rename SeqTupleHeaderSetXmax/Xmin to SeqTupleSetXmax/min and refactoring of the function; Now it will set HeapTuple and HeapTupleHeader xmax; > - add case of int64 values in check_GUC_init; > - massive refactoring in htup_details.h to use inline functions with type control over macro; > - reorder code in htup_details.h to reduce overall diff. > > As always, reviews and opinions are very welcome! 0008 needs a rebase. heapam.h and catversion.h are failing. Regards Thom
В списке pgsql-hackers по дате отправления
От: Melih Mutlu
Дата: