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

From: Timur Magomedov <t(dot)magomedov(at)postgrespro(dot)ru>
To: "Aya Iwata (Fujitsu)" <iwata(dot)aya(at)fujitsu(dot)com>
Cc: Peter Smith <smithpb2250(at)gmail(dot)com>, "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Tomas Vondra <tomas(at)vondra(dot)me>, Japin Li <japinli(at)hotmail(dot)com>, shveta malik <shveta(dot)malik(at)gmail(dot)com>, "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>, 'Alexandre Felipe' <o(dot)alexandre(dot)felipe(at)gmail(dot)com>, Álvaro Herrera <alvherre(at)kurilemu(dot)de>
Subject: Re: [WIP]Vertical Clustered Index (columnar store extension) - take2
Date: 2026-02-17 16:59:28
Message-ID: 9bebf705a4565fad027dda4ed09df020c94270b9.camel@postgrespro.ru
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello, Iwata-san.
> > 2. VCI has own Change Data Capture method. It doesn't use triggers
> > either logical replication for CDC, it uses IAM and homegrown hooks
> > in
> > heapam.c. Probably VCI-style CDC could be separated to its own
> > patch
> > for review and used in other extensions too.
>
> Could you elaborate a bit more on your thoughts regarding this?
> For example, what kind of hook functionality is thought to be useful?
> It's helpful if we decide hooks are really needed after some
> research,
> and we have to propose them separately.

All changes to core PostgreSQL code is currently maintained in a single
VCI-changes-to-postgres-core patch. It would be probably simpler to
review and accept if CDC patch was separated on its own. It would
contain hooks and anything else which allows VCI (or possibly any other
index) to get fresh data from table. Maybe we even don't need some
hooks but can extend IAM API instead.
--
Regards,
Timur Magomedov

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Aditya Kamath 2026-02-17 17:03:00 RE: AIX support
Previous Message Mark Wong 2026-02-17 16:45:32 Re: Recommended TPC-DS tools/setup for PostgreSQL benchmarking?