I'll attempt this next week.
On Fri, Jun 5, 2020, 21:11 Michael Lewis <mlewis@xxxxxxxxxxx> wrote:
Those row estimates are pretty far off.
Standard indexes and partial indexes don't get custom statistics created on them, but functional indexes do. I wonder if a small function needs_backup( shouldbebackedup, backupperformed ) and an index created on that function would nicely alleviate the pain. I would expect PG12 and extended statistics of type MCVs would bypass the need for that work around though.
