Re: Need for re-index after pg_upgrade

On 06/29/2015 06:42 AM, Tom Lane wrote:
> Andreas Joseph Krogh <andreas(at)visena(dot)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(dot)klaver(at)aklaver(dot)com