回复: Add 64-bit XIDs into PostgreSQL 15 - Mailing list pgsql-hackers

From adherent postgres
Subject 回复: Add 64-bit XIDs into PostgreSQL 15
Date
Msg-id TY0PR0101MB458680C7502DF316CD46CD1E8E1C9@TY0PR0101MB4586.apcprd01.prod.exchangelabs.com
Whole thread Raw
In response to Re: Add 64-bit XIDs into PostgreSQL 15  (Pavel Borisov <pashkin.elfe@gmail.com>)
List pgsql-hackers
Hi Pavel Borisov 
    Now the disk performance has been improved many times, and the capacity has also been increased many times,The wal log already supports lz4 and zstd compression, I think each XLOG record size will increase at least by 4 bytes which is not a big problem.What about your opinion?

Best whish



发件人: Pavel Borisov <pashkin.elfe@gmail.com>
发送时间: 2022年12月9日 22:13
收件人: adherent postgres <adherent_postgres@hotmail.com>
抄送: Aleksander Alekseev <aleksander@timescale.com>; pgsql-hackers@lists.postgresql.org <pgsql-hackers@lists.postgresql.org>; Chris Travers <chris.travers@gmail.com>; Chris Travers <chris@orioledata.com>; Bruce Momjian <bruce@momjian.us>
主题: Re: Add 64-bit XIDs into PostgreSQL 15
 
Hi, Adherent!

On Fri, 9 Dec 2022 at 17:54, adherent postgres
<adherent_postgres@hotmail.com> wrote:
>
> Hi Aleksander Alekseev
>  I think the xids 32bit transformation project has been dragged on for too long. Huawei's openGauss referenced this patch to implement xids 64bit, and Postgrespro also implemented xids 64bit, which is enough to prove that their worries are redundant.I think postgresql has no reason not to implement xid 64 bit. What about your opinion?

I agree it's high time to commit 64xids into PostgreSQL.

If you can do your review of the whole proposed patchset or only the
part that is likely to be committed earlier [1] it would help a lot!
I'd recommend beginning with the last version of the patch in thread
[1]. First, it is easier. Also, this review is going to be useful
sooner and will help a committer on January commitfest a lot.
[1]: https://www.postgresql.org/message-id/CAFiTN-uudj2PY8GsUzFtLYFpBoq_rKegW3On_8ZHdxB1mVv3-A%40mail.gmail.com

Regards,
Pavel Borisov,
Supabase

pgsql-hackers by date:

Previous
From: Danil Anisimow
Date:
Subject: Re: POC PATCH: copy from ... exceptions to: (was Re: VLDB Features)
Next
From: Maxim Orlov
Date:
Subject: Re: Add 64-bit XIDs into PostgreSQL 15