Hacker News new | ask | show | jobs
by pg314 3397 days ago
Have you looked into pg_repack [1]? It's a PostgreSQL extension that can CLUSTER online, without holding an exclusive lock. I haven't used it, but it looks interesting as an alternative to the built-in CLUSTER.

[1] http://reorg.github.io/pg_repack/