On Tue, Aug 30, 2016 at 8:17 PM, Kenneth Marshall <k...@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? Is it compatible with PostgreSQL 9.6?