Re: Understanding partial index selection

Owen Nelson <onelson@gmail.com> writes:
>> Are your ANALYZE stats up to date on this table?

> It's a very good question! Right now, I'm taking it on faith that
> autovacuum and autoanalyze are keeping things up to date, but if I'm honest
> I've been getting some conflicting information from pg_stat_user_tables and
> I'm starting to suspect this might be an AWS Aurora quirk.

Oh, you didn't say this was Aurora.  Aurora is not really Postgres ---
at least, my not-an-insider impression is that the storage engine
is quite different.  Not sure how much of the advice you got here
is relevant to it.

            regards, tom lane