Date: Mon, 8 Jul 2019 16:57:40 +0900
From: Michael Paquier <michael@paquier.xyz>
To: Julien Rouhaud <rjuju123@gmail.com>
Cc: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>,
	Alvaro Herrera <alvherre@2ndquadrant.com>,
	Thomas Munro <thomas.munro@gmail.com>,
	Daniel Verite <daniel@manitou-mail.org>,
	Tom Lane <tgl@sss.pgh.pa.us>,
	PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>,
	Kevin Grittner <kgrittn@gmail.com>
Subject: Re: Add parallelism and glibc dependent only options to reindexdb
Message-ID: <20190708075740.GF2709@paquier.xyz>
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>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="OzxllxdKGCiKxUZM"
Content-Disposition: inline
In-Reply-To: 
 <CAOBaU_bX6u=dYiCk_SJPcxQR5LR4L5tieUq71FqPjf+nk_VbZQ@mail.gmail.com>
Precedence: bulk


--OzxllxdKGCiKxUZM
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Fri, Jul 05, 2019 at 07:25:41PM +0200, Julien Rouhaud wrote:
> On Fri, Jul 5, 2019 at 6:16 PM Peter Eisentraut <peter.eisentraut@2ndquad=
rant.com> wrote:
>> Isn't that also the case for your proposal?  We are not going to release
>> a new reindexdb before a new REINDEX.
>=20
> Sure, but my point was that once the new reindexdb is released (or if
> you're so desperate, using a nightly build or compiling your own), it
> can be used against any previous major version.  There is probably a
> large fraction of users who don't perform a postgres upgrade when they
> upgrade their OS, so that's IMHO also something to consider.

I think that we need to think long-term here and be confident in the
fact we will still see breakages with collations and glibc, using a
solution that we think is the right API.  Peter's idea to make the
backend-aware command of the filtering is cool.  On top of that, there
is no need to add any conflict logic in reindexdb and we can live with
restricting --jobs support for non-index objects.
--
Michael

--OzxllxdKGCiKxUZM
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl0i93QACgkQnvQgOdby
QH3zuA/+LJyn3anipPMhxH7TgmHRvQQna/HudiP0sKcfOfJJGjOrmb4Pt1PTnpdi
75MeL+8xtORrnNYJNJxR4ghZyAAgjF3/nPTEpvh+IOtO8BL9BevQ4BxnZRBwAMKO
SHXuOof+UeJcDKBpEgzm1tSMK+vNj7JgZgOv3+L0pwDuzkSrYh4RFwWcsx+ieb+d
o4vDp5UClC5tAbGyc9A6LjZwo1CoMdFI0rBC7A84THoqPWimpjilNL4roKhrtQhe
7rRIzm8LYFypjwUF2TKyuzKFLmoXiUMvaziyyoxbBfAPT3I5NLyb+fwe6fAA8f2m
/Q3CSrkSywV+I8Es2clXA0F8mrVnkfPf/XiSDBkNsC8j4e44OEwXsqifAetErYEo
KFYCbcY7KmgrYFf4oRTf5lyeNvUjwS3hx3pzsUBi+bD5krGXS98sfCRe2sQhgY7+
IIkQe5FagSzro2qf4rmcist42E221iaz2cKoKNruzr/IlAOExzPofCeRfsqe7Cx0
9ilRaQ5/2XfJfbSgBkrpjAcAf3vluCrNVU+Z5ZBDsttfPqjFfMRCthFxz02C58Bc
GGkPg4gktVhG3jXShayChkQrIWu0raZTQGouhNl4+L6A+2T5S639m0As3jahvslj
/0nfNV1F1TnamNM3xNcTivOawcfK4i4cwW6wGYQHeqs/ErYUONI=
=+UmC
-----END PGP SIGNATURE-----

--OzxllxdKGCiKxUZM--