Re: Understanding partial index selection - Mailing list pgsql-general

From Tom Lane
Subject Re: Understanding partial index selection
Date
Msg-id 205440.1701222268@sss.pgh.pa.us
Whole thread Raw
In response to Re: Understanding partial index selection  (Owen Nelson <onelson@gmail.com>)
Responses Re: Understanding partial index selection  (Owen Nelson <onelson@gmail.com>)
List pgsql-general
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



pgsql-general by date:

Previous
From: Owen Nelson
Date:
Subject: Re: Understanding partial index selection
Next
From: Owen Nelson
Date:
Subject: Re: Understanding partial index selection