As it happens our larger tables operate as a business log and are also insert only.
- There is no partitioning at this time since we expect to have an automated process to delete rows older than a certain date.
- Analyzing doing off-hours sounds like a good idea; if there is no other way to determine effect on db we may end up doing that.
- We have an open schema and heavily depend on jsonb, so I'm not sure if increasing the statistics target will be helpful.
Thanks