Re: undead index - Mailing list pgsql-general

From Cédric Villemain
Subject Re: undead index
Date
Msg-id BANLkTikgk7q3KBBE2OMAs6YcxpwHDjrftg@mail.gmail.com
Whole thread Raw
In response to undead index  (Jens Wilke <jens.wilke@affinitas.de>)
Responses Re: undead index
List pgsql-general
2011/5/4 Jens Wilke <jens.wilke@affinitas.de>:
>
> This index was deleted several weeks ago.
>
[...]
>
> after pg_dumpall|psql from 8.4 to 9.0 the undead index revived on the target
> DB:

I understood that you droped an index and when you dump/restore you
get your index again.
Did I miss something ?

--
Cédric Villemain               2ndQuadrant
http://2ndQuadrant.fr/     PostgreSQL : Expertise, Formation et Support

pgsql-general by date:

Previous
From: David Boreham
Date:
Subject: Re: SSDD reliability
Next
From: John Cheng
Date:
Subject: Cannot reproduce why a query is slow