Horton

Re: Partitioned index can be not dumped

Alvaro Herrera <alvherre@alvh.no-ip.org>

View thread View on postgr.es
From: Álvaro Herrera <alvherre@alvh.no-ip.org>
To: Zhihong Yu <zyu@yugabyte.com>
Cc: Alexander Pyhalov <a.pyhalov@postgrespro.ru>, Pgsql Hackers <pgsql-hackers@postgresql.org>
Date: 2021-06-30T21:32:40Z
Lists: pgsql-hackers 
On 2021-Jun-30, Zhihong Yu wrote:

> Hi,
> nit:
> -       if (hasindex)
> +       if (nindexes > 0)
> 
> It seems hasindex is no longer needed since nindexes is checked.

It's still used to call vac_update_relstats().  We want nindexes to be 0
for partitioned tables, but still pass true when there are indexes.

Please don't forget to trim the text of the email you're replying to.

-- 
Álvaro Herrera                        Valdivia, Chile
                        https://www.EnterpriseDB.com/

Commits

  1. Don't reset relhasindex for partitioned tables on ANALYZE

  2. Set pg_class.reltuples for partitioned tables

  3. autovacuum: handle analyze for partitioned tables