Erik Nordström <erik@timescale.com> wrote:
> Hi hackers,
>
> I've been looking at the code for CLUSTER/VACUUM FULL, and whether it is possible to do a concurrent version of it
usinga
> multi-transactional approach similar to concurrent reindexing and partition detach.
>
> The idea would be to hold weaker locks in TX1 when doing the heap rewrite (essentially allow reads but prevent
writes),and then do the
> actual heap swap in a second TX2 transaction.
Patch [1] is in the queue that allows both reads and writes. (An exclusive
lock is acquired here for the swaps, but that should be held for very short
time.)
--
Antonin Houska
Web: https://www.cybertec-postgresql.com
[1] https://commitfest.postgresql.org/patch/5117/
