On Fri, Feb 28, 2020 at 11:41 AM Michael Lewis <mle...@entrata.com> wrote:
> If no updates or deletes are happening on the table, it would be best > practice to set up a scheduled manual vacuum analyze to ensure statistics > and the visibility map is updated. Other than creating the index on the > first two columns only, I'm out of ideas. Hopefully someone running > Postgres at large scale on Windows will chime in. > Yep. We run manual vacuum freeze analyze weekly to ensure visibility map is updated and statistics are up to date. Thanks for taking the time to look.
