Hacker News new | ask | show | jobs
by cldellow 3564 days ago
As others have mentioned, if your workload is mostly appends and the data is appended in the correct order, you don't need to redo the clustering. In our case, the clustering was a one-off to get the data in the right shape.

(Although if you do need to redo clustering, look into pg_repack.)