In Postgres, one can set fillfactor for an index as well as a table. What is the difference? How to decide values for either. What are the usecases?
I am trying to cluster a spatial relation on a spatial index. It has a couple of million records. The records are updated all the time though very few new ones are created daily.
The use case is spatial range queries. What will be a good value for the table fillfactor and / or the index fillfactor?