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
Ответ на
Список
Дерево обсуждения
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 по дате отправления
От: Michael Paquier
Дата:
Сообщение: Re: Unit tests for SLRU
От: Melih Mutlu
Дата:
FAQ