https://reorg.github.io/pg_repack/ ? remove bloat from tables and indexes, and optionally restore the physical order of clustered indexes. Unlike CLUSTER and VACUUM FULL it works online, without holding an exclusive lock on the processed tables during processing. pg_repack is efficient to boot, with performance comparable to using CLUSTER directly.
[^] # Re: quelques pistes
Posté par BAud (site web personnel) . En réponse au message Gros ralentissement sur une base Postgresql 10. Évalué à 4.
https://reorg.github.io/pg_repack/ ?
remove bloat from tables and indexes, and optionally restore the physical order of clustered indexes. Unlike CLUSTER and VACUUM FULL it works online, without holding an exclusive lock on the processed tables during processing. pg_repack is efficient to boot, with performance comparable to using CLUSTER directly.
faut trouver les bonnes options ;-)