Re: [HACKERS] REINDEX CONCURRENTLY 2.0 - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: [HACKERS] REINDEX CONCURRENTLY 2.0
Date
Msg-id 93a3d2fb-43a0-cf14-e8d0-d2c3195c1e5b@2ndquadrant.com
Whole thread Raw
In response to Re: [HACKERS] REINDEX CONCURRENTLY 2.0  (Sergei Kornilov <sk@zsrv.org>)
Responses Re: [HACKERS] REINDEX CONCURRENTLY 2.0  (Sergei Kornilov <sk@zsrv.org>)
List pgsql-hackers
On 07/12/2018 17:40, Sergei Kornilov wrote:
> I perform some tests and think behavior with partition tables is slightly inconsistent.
> 
> postgres=# reindex table measurement;
> WARNING:  REINDEX of partitioned tables is not yet implemented, skipping "measurement"
> NOTICE:  table "measurement" has no indexes
> REINDEX
> postgres=# reindex table CONCURRENTLY measurement;
> ERROR:  cannot reindex concurrently this type of relation
> 
> Maybe we need report warning and skip partitioned tables similar to plain reindex?

OK, that should be easy to fix.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_partition_tree crashes for a non-defined relation
Next
From: Peter Eisentraut
Date:
Subject: Re: make install getting slower