On Sun, 2023-07-30 at 23:00 -0600, peter plachta wrote:
> Background is we're trying a pg_repack-like functionality to compact a
> 500Gb/145Gb
> index (x2) table from which we deleted 80% rows. Offline is not an option.
> The table
> has a moderate (let's say 100QPS) I/D workload running.
>
> Th
Hi all
Background is we're trying a pg_repack-like functionality to compact a
500Gb/145Gb index (x2) table from which we deleted 80% rows. Offline is not
an option. The table has a moderate (let's say 100QPS) I/D workload running.
The typical procedure for this type of thing is basically CDC:
1.
