We're using a time-based partitioning scheme for our data and so partitions become "read only" once the time covered by it has passed. We've been CLUSTERing those partitions but here's some questions I have:
Should we set the fill factor of the indexes from the default of 90 to 100?
Should we do anything with xids and freeze age?Should we set the fill factor of the indexes from the default of 90 to 100?
Anything else?
Thanks,