回复: Add 64-bit XIDs into PostgreSQL 15
| От | adherent postgres |
|---|---|
| Тема | 回复: Add 64-bit XIDs into PostgreSQL 15 |
| Дата | |
| Msg-id | TY0PR0101MB458680C7502DF316CD46CD1E8E1C9@TY0PR0101MB4586.apcprd01.prod.exchangelabs.com обсуждение исходный текст |
| Ответ на | Re: Add 64-bit XIDs into PostgreSQL 15 (Pavel Borisov <pashkin.elfe@gmail.com>) |
| Список | 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
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
发送时间: 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
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 по дате отправления: