On 06/29/2015 06:42 AM, Tom Lane wrote:
Andreas Joseph Krogh <andreas@xxxxxxxxxx> writes:
In the man-page for pg_upgrade we see this:
pg_upgrade will require a reindex if:
* an index is of type hash or GIN
I think that probably refers to some version-specific upgrade
situations; I can't see a reason why it would be true in general.
Bruce, doesn't that doc need improvement?
Yes for coming from 8.3:
http://www.postgresql.org/docs/9.4/static/pgupgrade.html
Limitations in Upgrading from PostgreSQL 8.3
....
pg_upgrade will require a reindex if:
an index is of type hash or GIN
an index uses bpchar_pattern_ops
This how it shows up my 9.4 man file also.
regards, tom lane
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general