pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
To: Michael Paquier <michael@paquier.xyz>
Cc: Shinoda, Noriyoshi (PN Japan A&PS Delivery) <noriyoshi.shinoda@hpe.com>
Cc: Sergei Kornilov <sk@zsrv.org>
Cc: pgsql-hackers@lists.postgresql.org <pgsql-hackers@lists.postgresql.org>
Subject: Re: REINDEX CONCURRENTLY 2.0
Date: Fri, 12 Apr 2019 08:44:18 +0200
Message-ID: <72eef7dd-0fc8-6d90-600d-3f1f501d6c04@2ndquadrant.com> (raw)
In-Reply-To: <20190411035952.GL2728@paquier.xyz>
References: <7380711553760479@iva5-0acfc31d2b43.qloud-c.yandex.net>
	<13fb3e06-3b66-e878-26d8-0d77e7d50160@2ndquadrant.com>
	<14715291553845163@iva7-8175209a746b.qloud-c.yandex.net>
	<20190329080426.GA1954@paquier.xyz>
	<776f5793-3687-2ba9-913b-a3d5c820bafe@2ndquadrant.com>
	<20190329092122.GC1954@paquier.xyz>
	<DF4PR8401MB11964EDB77C860078C343BEBEE5A0@DF4PR8401MB1196.NAMPRD84.PROD.OUTLOOK.COM>
	<ec449ece-5e7f-f1f2-6e6c-81e305e9af81@2ndquadrant.com>
	<20190401064343.GA16093@paquier.xyz>
	<20190409065027.GC19558@paquier.xyz>
	<20190411035952.GL2728@paquier.xyz>

On 2019-04-11 05:59, Michael Paquier wrote:
> On Tue, Apr 09, 2019 at 03:50:27PM +0900, Michael Paquier wrote:
>> And here is the patch to address this issue.  It happens that a bit
>> more than the dependency switch was lacking here:
>> - At swap time, we need to have the new index definition track
>> relispartition from the old index.
>> - Again at swap time, the inheritance link needs to be updated between
>> the old/new index and its parent when reindexing a partition index.
> 
> Peter, this is an open item, and I think as the committer of the
> feature you are its owner.  Well, in this case, I don't mind taking
> the ownership as need be as I know this stuff.  Anyway, could you have
> a look at the patch proposed and see if you have any issues with it?

Looks good, committed.

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





view thread (170+ messages)  latest in thread

Message-ID: <72eef7dd-0fc8-6d90-600d-3f1f501d6c04@2ndquadrant.com>
Permalink:  ../72eef7dd-0fc8-6d90-600d-3f1f501d6c04@2ndquadrant.com/
Also on:    postgresql.org/message-id/72eef7dd-0fc8-6d90-600d-3f1f501d6c04@2ndquadrant.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: peter.eisentraut@2ndquadrant.com, michael@paquier.xyz, noriyoshi.shinoda@hpe.com, sk@zsrv.org, pgsql-hackers@lists.postgresql.org
  Subject: Re: REINDEX CONCURRENTLY 2.0
  In-Reply-To: <72eef7dd-0fc8-6d90-600d-3f1f501d6c04@2ndquadrant.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox