Thread: Need for re-index after pg_upgrade

Need for re-index after pg_upgrade

From
Andreas Joseph Krogh
Date:
Hi all.
 
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

 
A bit further up we see:
All failure, rebuild, and reindex cases will be reported by pg_upgrade if they affect your installation; post-upgrade scripts to rebuild tables and indexes will be generated automatically.
 
I have several GIN-indexes and upgraded from 9.3 to 9.4 but no re-index scripts were generated. Does this mean there's no need to rebuild the indexes or just that I have to do it manually?
 
Thanks.
 
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
Attachment

Re: Need for re-index after pg_upgrade

From
Tom Lane
Date:
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?

            regards, tom lane


Re: Need for re-index after pg_upgrade

From
Andreas Joseph Krogh
Date:
På mandag 29. juni 2015 kl. 15:42:22, skrev Tom Lane <tgl@sss.pgh.pa.us>:
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?

regards, tom lane
 
I'm specifically thinking about this (from 9.4 release-notes):

E.5.3.1.1. Indexes

  • Reduce GIN index size (Alexander Korotkov, Heikki Linnakangas)

    Indexes upgraded via pg_upgrade will work fine but will still be in the old, larger GIN format. Use REINDEX to recreate old GIN indexes in the new format.

 
It'd be great if pg_upgrade generated re-index scripts to make those indexes use the new format.
 
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
 
Attachment

Re: Need for re-index after pg_upgrade

From
Adrian Klaver
Date:
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