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>
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 |