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.
Hi all
My colleague and I did some experiments to see what effect using UUIDs as
2nd-ary indexes has on Index IO. The context is that by default ORM
frameworks will use UUIDs as index keys which I found as a major factor to
performance issues at Celonis. I suspect this isn't specific to Celonis.
T
