Re: Postgresql concern of effect of invalid index - Mailing list pgsql-bugs

From Matheus de Oliveira
Subject Re: Postgresql concern of effect of invalid index
Date
Msg-id CAJghg4JCpNr_ZQuZETjnXA+8TB6rPug7Qz1SOA4wcYb3G434sQ@mail.gmail.com
Whole thread Raw
In response to Re: Postgresql concern of effect of invalid index  (Kevin Grittner <kgrittn@ymail.com>)
List pgsql-bugs
On Sun, Aug 24, 2014 at 8:45 AM, Kevin Grittner <kgrittn@ymail.com> wrote:

> > If you marked it as invalid, then it is not going to be updated
> > anymore.
>
> I think you are confusing indisvalid with indisready:
>
> http://www.postgresql.org/docs/current/interactive/catalog-pg-index.html
>
> Flagging it is invalid should suppress its use for queries, yet
> still do all the work of maintaining it.



You are right. Sorry about the noise.

Regards,
--=20
Matheus de Oliveira
Analista de Banco de Dados
Dextra Sistemas - MPS.Br n=C3=ADvel F!
www.dextra.com.br/postgres

pgsql-bugs by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: Postgresql concern of effect of invalid index
Next
From: dbhandary@switchfly.com
Date:
Subject: BUG #11264: Auto vacuum wraparound job blocking everything