Re: Need for re-index after pg_upgrade

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