On 06/29/2015 06:42 AM, Tom Lane wrote:
> Andreas Joseph Krogh <andreas@visena.com> 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@aklaver.com