On Tue, Aug 30, 2016 at 8:17 PM, Kenneth Marshall <ktm@rice.edu> wrote:
We have been using the extension pg_repack to keep a table groomed into cluster order. With an appropriate FILLFACTOR to keep updates on the same page, it works well. The issue is that it needs space to rebuild the new index/table. If you have that, it works well.
Interesting!
Do you run pg_repack on a regular schedule using something like cron, or does it run automatically in the background?
