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

help / color / mirror / Atom feed
From: Michael Paquier <michael@paquier.xyz>
To: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Cc: Julien Rouhaud <rjuju123@gmail.com>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: Thomas Munro <thomas.munro@gmail.com>
Cc: Daniel Verite <daniel@manitou-mail.org>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Cc: Kevin Grittner <kgrittn@gmail.com>
Subject: Re: Add parallelism and glibc dependent only options to reindexdb
Date: Wed, 10 Jul 2019 13:46:18 +0900
Message-ID: <20190710044618.GC1031@paquier.xyz> (raw)
In-Reply-To: <2ea2dfd0-ef48-68c1-d1b5-004acffb5ef6@2ndquadrant.com>
References: <20190701214648.GA9427@alvherre.pgsql>
	<7140716c-679e-a0b9-a273-b201329d8891@2ndquadrant.com>
	<CAOBaU_a-puHZ4pc0a4dMTnFShuU7jORmKFQN29RyzGomVj1CSQ@mail.gmail.com>
	<abd97c36-b3a8-643e-7d25-2e54c74e78ea@2ndquadrant.com>
	<CAOBaU_bX6u=dYiCk_SJPcxQR5LR4L5tieUq71FqPjf+nk_VbZQ@mail.gmail.com>
	<20190708075740.GF2709@paquier.xyz>
	<CAOBaU_btyz1d08r7S2oWHUPKdyxKKp5=jS3rhycgO8jNuLUcPg@mail.gmail.com>
	<2ea2dfd0-ef48-68c1-d1b5-004acffb5ef6@2ndquadrant.com>

On Tue, Jul 09, 2019 at 01:09:38PM +0200, Peter Eisentraut wrote:
> You can already do that: Run a query through psql to get a list of
> affected tables or indexes and feed those to reindexdb using -i or -t
> options.

Sure, but that's limited if one can only afford a limited amount of
downtime for an upgrade window and you still need to handle properly
the index-level conflicts when doing the processing in parallel.
--
Michael

Attachments:

  signature.asc (application/pgp-signature, 832B) download

view thread (78+ messages)  latest in thread

Message-ID: <20190710044618.GC1031@paquier.xyz>
Permalink:  ../20190710044618.GC1031@paquier.xyz/
Also on:    postgresql.org/message-id/20190710044618.GC1031@paquier.xyz

 · 

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: michael@paquier.xyz, peter.eisentraut@2ndquadrant.com, rjuju123@gmail.com, alvherre@2ndquadrant.com, thomas.munro@gmail.com, daniel@manitou-mail.org, tgl@sss.pgh.pa.us, pgsql-hackers@lists.postgresql.org, kgrittn@gmail.com
  Subject: Re: Add parallelism and glibc dependent only options to reindexdb
  In-Reply-To: <20190710044618.GC1031@paquier.xyz>

* 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