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>
Date: 2021-06-30T14:44:13Z
Lists: pgsql-hackers 
On 2021-Jun-30, Alexander Pyhalov wrote:

> Hi.
> 
> I've seen the following effect on PostgreSQL 14 stable branch.
> Index, created on partitioned table, disappears from pg_dump or psql \d
> output.
> This seems to begin after analyze. Partitoned relation relhasindex pg_class
> field suddenly becomes false.

Uh, ouch.

I'll look into this shortly.



-- 
Á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