Re: [WIP]Vertical Clustered Index (columnar store extension) - take2

From: Peter Smith <smithpb2250(at)gmail(dot)com>
To: Timur Magomedov <t(dot)magomedov(at)postgrespro(dot)ru>
Cc: "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Tomas Vondra <tomas(at)vondra(dot)me>, "Aya Iwata (Fujitsu)" <iwata(dot)aya(at)fujitsu(dot)com>, Japin Li <japinli(at)hotmail(dot)com>, shveta malik <shveta(dot)malik(at)gmail(dot)com>
Subject: Re: [WIP]Vertical Clustered Index (columnar store extension) - take2
Date: 2025-11-17 22:45:39
Message-ID: CAHut+PvUqzjDC0Fi1ZzcTj0JTgv0nALXZsfPL-8Ue7cc3ko5zg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Nov 18, 2025 at 1:32 AM Timur Magomedov
<t(dot)magomedov(at)postgrespro(dot)ru> wrote:
> Hello Peter!
> Thanks for updating the patch!
> According to the issue I've found recently with incorrect WAL record
> [1], I've prepared a patch that replaces manual XLog...() calls by a
> call to log_heap_prune_and_freeze() in a way similar to what
> freezeWos() and lazy_vacuum_heap_page() do. This fixes reproducer
> scenario on my machine.
>
> [1]
> https://www.postgresql.org/message-id/36cedffdfcac437afd692442cf9c1d16d7f28b01.camel%40postgrespro.ru
>

Here are the latest patches.

Changes include:

PATCH 0002.
- Merged the fix provided by Timur [1].

======
[1] https://www.postgresql.org/message-id/1de545d00a5c0bb8aaf42f05dd118a2c19030041.camel%40postgrespro.ru

Kind Regards,
Peter Smith.
Fujitsu Australia

Attachment Content-Type Size
v20251118-0003-VCI-module-documentation.patch application/octet-stream 5.4 KB
v20251118-0001-VCI-changes-to-postgres-core.patch application/octet-stream 59.9 KB
v20251118-0002-VCI-module-main.patch application/octet-stream 1.3 MB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Shinya Kato 2025-11-17 22:52:58 Re: Speed up COPY FROM text/CSV parsing using SIMD
Previous Message Nathan Bossart 2025-11-17 22:26:55 Re: vacuumdb: add --dry-run