I'll attempt this next week. On Fri, Jun 5, 2020, 21:11 Michael Lewis <mle...@entrata.com> 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. >