Re: Clarification on the release notes of postgresql 12 regarding pg_upgrade

2019-10-04 Thread Bruce Momjian
On Fri, Oct 4, 2019 at 09:43:31AM -0700, Peter Geoghegan wrote: > On Fri, Oct 4, 2019 at 9:09 AM Tom Lane wrote: > > > You can't REINDEX safely regarding that note. > > > > Actually running into that problem is quite unlikely; and if you did > > hit it, it'd just mean that the REINDEX fails, not

Re: Clarification on the release notes of postgresql 12 regarding pg_upgrade

2019-10-04 Thread Peter Geoghegan
On Fri, Oct 4, 2019 at 9:09 AM Tom Lane wrote: > > You can't REINDEX safely regarding that note. > > Actually running into that problem is quite unlikely; and if you did > hit it, it'd just mean that the REINDEX fails, not that you have any > urgent problem to fix. I'd encourage you to just go

Re: Clarification on the release notes of postgresql 12 regarding pg_upgrade

2019-10-04 Thread Tom Lane
=?UTF-8?B?Sm9zZWYgxaBpbcOhbmVr?= writes: > But the problem in this case is probably this note: >> This means that a REINDEX >> operation on an >> index pg_upgrade'd from a previous release could potentially fail. > You can't REINDEX safely

Re: Clarification on the release notes of postgresql 12 regarding pg_upgrade

2019-10-04 Thread Josef Šimánek
But the problem in this case is probably this note: > This means that a REINDEX operation on an index pg_upgrade'd from a previous release could potentially fail. You can't REINDEX safely regarding that note. pá 4. 10. 2019 v 16:06

Re: Clarification on the release notes of postgresql 12 regarding pg_upgrade

2019-10-04 Thread Laurenz Albe
On Fri, 2019-10-04 at 10:00 -0300, Marcelo Lacerda wrote: > There are a few instances where the release notes seem to indicate > that the administrator should use pg_dump to upgrade a database so > that improvements on btree can be available. > > Here are they: > > 1. > > >In new btree

Clarification on the release notes of postgresql 12 regarding pg_upgrade

2019-10-04 Thread Marcelo Lacerda
There are a few instances where the release notes seem to indicate that the administrator should use pg_dump to upgrade a database so that improvements on btree can be available. Here are they: 1. >In new btree indexes, the maximum index entry length is reduced by eight bytes, to improve