Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_upgrade problem with invalid indexes - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: pg_upgrade problem with invalid indexes
Date
Msg-id 20121207040226.GF4299@alvh.no-ip.org
Whole thread Raw
In response to Re: pg_upgrade problem with invalid indexes  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: pg_upgrade problem with invalid indexes
List pgsql-hackers
Tree view 
Andrew Dunstan wrote:
>
> On 12/06/2012 09:23 PM, Bruce Momjian wrote:

> >As soon as pg_dump stopped dumping the CREATE INDEX, pg_upgrade would
> >stop creating creating it in the new cluster, and not transfer the index
> >files.
>
> So we'll lose the index definition and leave some files behind? This
> sounds a bit messy to say the least.

I find it hard to get excited about this being a real problem.  If the
index has been kept invalid, how come the definition is so valuable?

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

pgsql-hackers by date:

Previous
From: Phil Sorber
Date:
Subject: Re: [WIP] pg_ping utility
Next
From: Pavan Deolasee
Date:
Subject: Re: Setting visibility map in VACUUM's second phase