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: Alexander Pyhalov <a.pyhalov@postgrespro.ru>
Cc: Pgsql Hackers <pgsql-hackers@postgresql.org>, Zhihong Yu <zyu@yugabyte.com>
Date: 2021-07-01T17:01:19Z
Lists: pgsql-hackers 
On 2021-Jun-30, Alexander Pyhalov wrote:

> Looks good. It seems this comment refers to line 455.

Ah, so it does.

I realized that we don't need to do vac_open_indexes for partitioned
tables: it is sufficient to know whether there are any indexes at all.
So I replaced that with RelationGetIndexList() and checking if the list
is nonempty, specifically for the partitioned table case.  Pushed now.

Thanks for reporting and fixing this, and to Zhihong Yu for reviewing.

-- 
Álvaro Herrera              Valdivia, Chile  —  https://www.EnterpriseDB.com/
"Investigación es lo que hago cuando no sé lo que estoy haciendo"
(Wernher von Braun)

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