| From: | John Naylor <johncnaylorls(at)gmail(dot)com> |
|---|---|
| To: | Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Nathan Bossart <nathandbossart(at)gmail(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>, Yura Sokolov <y(dot)sokolov(at)postgrespro(dot)ru> |
| Subject: | Re: [PoC] Improve dead tuple storage for lazy vacuum |
| Date: | 2024-04-07 02:08:40 |
| Message-ID: | CANWCAZZeLrDjxNkP78D_M6Uw_0dS8CZhFf6LP5UFGz7qGm2jUA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, Apr 1, 2024 at 9:54 AM Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> wrote:
>
> Thank you! I've attached the patch that I'm going to push tomorrow.
Excellent!
I've attached a mostly-polished update on runtime embeddable values,
storing up to 3 offsets in the child pointer (1 on 32-bit platforms).
As discussed, this includes a macro to cap max possible offset that
can be stored in the bitmap, which I believe only reduces the valid
offset range for 32kB pages on 32-bit platforms. Even there, it allows
for more line pointers than can possibly be useful. It also splits
into two parts for readability. It would be committed in two pieces as
well, since they are independently useful.
| Attachment | Content-Type | Size |
|---|---|---|
| v83-0001-store-offsets-in-the-header.patch | text/x-patch | 5.5 KB |
| v83-0002-pgindent.patch | text/x-patch | 4.2 KB |
| v83-0003-Teach-radix-tree-to-embed-values-at-runtime.patch | text/x-patch | 8.1 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2024-04-07 02:55:04 | Re: Fixing backslash dot for COPY FROM...CSV |
| Previous Message | John Naylor | 2024-04-07 01:40:15 | Re: Change GUC hashtable to use simplehash? |