Need for re-index after pg_upgrade

From: Andreas Joseph Krogh <andreas(at)visena(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Need for re-index after pg_upgrade
Date: 2015-06-29 10:15:51
Message-ID: VisenaEmail.19.bf6d45347c607613.14e3ecde54f@tc7-visena
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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
andreas(at)visena(dot)com <mailto:andreas(at)visena(dot)com>
www.visena.com <https://www.visena.com>
<https://www.visena.com>

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Francisco Olarte 2015-06-29 11:44:24 Re: Inserting from multiple processes?
Previous Message Stéphane Schildknecht 2015-06-29 09:38:59 Re: pg_xlog on a hot_stanby slave