Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g1qr7-00063N-2j for pgsql-hackers@arkaria.postgresql.org; Mon, 17 Sep 2018 10:34:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1g1qr5-0003Rv-6M for pgsql-hackers@arkaria.postgresql.org; Mon, 17 Sep 2018 10:34:11 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g1qr4-0003Rn-VT for pgsql-hackers@lists.postgresql.org; Mon, 17 Sep 2018 10:34:11 +0000 Received: from tamriel.snowman.net ([2001:470:e38f::11]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1g1qqx-000566-KM for pgsql-hackers@postgresql.org; Mon, 17 Sep 2018 10:34:09 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id CFCF55F79C; Mon, 17 Sep 2018 06:34:02 -0400 (EDT) Date: Mon, 17 Sep 2018 06:34:02 -0400 From: Stephen Frost To: Thomas Munro Cc: Douglas Doole , Peter Eisentraut , Christoph Berg , Pg Hackers Subject: Re: Collation versioning Message-ID: <20180917103402.GR4184@tamriel.snowman.net> References: <20180912081547.GA24584@msg.df7cb.de> <0447ec7b-cdb6-7252-7943-88a4664e7bb7@2ndquadrant.com> <20180912112548.GC24584@msg.df7cb.de> <4f60612c-a7b5-092d-1532-21ff7a106bd5@2ndquadrant.com> <20180916210215.GE4184@tamriel.snowman.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="5xOx87wJzmWs6TPt" Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.24 (2015-08-30) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --5xOx87wJzmWs6TPt Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Greetings, * Thomas Munro (thomas.munro@enterprisedb.com) wrote: > I'd like to propose the 3 more humble goals I mentioned a few messages > back as earlier steps. OS collation changes aren't really like Monty > Python's Spanish Inquisition: they usually hit you when you're doing > major operating system upgrades or setting up a streaming replica to a > different OS version IIUC. That is, they probably happen during > maintenance windows when REINDEX would hopefully be plausible, and > presumably critical systems get tested on the new OS version before > production is upgraded. It'd be kind to our users to make the problem > non-silent at that time so they can plan for it (and of course also > alert them if it happens when nobody expects it, because knowing you > have a problem is better than not knowing). Just to be clear, I'm all for this, but wanted to bring up the farther out goal to make sure we're thinking about how to eventually get there =66rom here- and to make sure we aren't making it more difficult to get there with the proposed catalog changes for these shorter-term goals. Thanks! Stephen --5xOx87wJzmWs6TPt Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJbn4MaAAoJEO1sijiDR2RVitYP/Aw79DLR4GV1tAYyocJCaauA 3TWka2W7zbu4PiLHD6V0xh1yNHHGcUYMZLhB5PbPGGD72K8eO8zQX4bjH01JlkpY XFnhvXJCt7a7roLFa3aLlSjMnX6d3UDN3VXON+s+ap7GbDSBSDtnvTxH5BNOsKPs u4AHDVg/MNmnYnMntfeptt6SL14hfNfUvpM3MXN99XZd7KYDsOWz8gRdwkg7svJm JMiqLzLw26UAjajyVj5tCd/yB1EYSqDwcRTaqf4LnQ6JMyBHSFK+l4iNDd33ZmUS CJPIwiZJzkMPLYL3Mgaswj8j4cLTxGow6qZFAuM9/IWNOlswEuP16v2fXNfjG4wF QAVOfL2nrZvRr1dDqSZNp7wA2Vkd3G351gAPobNx6Wt2+iK8/LU7cgOKpD+Xi+j/ +9wJ3SLGtBmLQVh384gbH1LgmsH5TTDTYyivbe6Rwm0Fm04KhGN4oqUmPTTXnUJZ pQYEw5R36+HXAvwj/HhwcUPPoYNBJVdyCQ1rEtgizpB6sZUOaLMUTnnQzsF/DL2Q adAWy3Ec7N/oIyo/oVvfoxvoHnHUnzfXcTldDxUorYZGcZz1pfg4S1Y+yCETh8NV aCcE4whJFnDwUq2G3FBaArRUUipSJzwCCa1Py4PL9YOb88q+WlJO0KVoL4qNqwg4 YVKVHBHhA9KoRcSy3cRg =vGhv -----END PGP SIGNATURE----- --5xOx87wJzmWs6TPt--