> On Jun 29, 2021, at 10:33 AM, Ron <ronljohnso...@gmail.com> wrote:
>
> Prod is brand new. Loaded on Saturday; we saw this problem on Sunday during
> pre-acceptance. Thus, while running ANALYZE was top of the list of Things To
> Do, running VACUUM was low.
>
> Is that a mistaken belief?
You might want to run VACUUM FREEZE and then retry your test query using
EXPLAIN. See if it switches to an index only scan after the VACUUM FREEZE.
—
Mark Dilger
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
