Postgres Pro
Downloads
Home   >   mailing lists

Re: Preventing index scans for non-recoverable index AMs - Mailing list pgsql-hackers

From Jaime Casanova
Subject Re: Preventing index scans for non-recoverable index AMs
Date
Msg-id 3073cc9b0812171501k4db33d10va5c361003bc3345a@mail.gmail.com
Whole thread Raw
In response to Re: Preventing index scans for non-recoverable index AMs  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: Preventing index scans for non-recoverable index AMs  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-hackers
Tree view 
On Wed, Dec 17, 2008 at 5:54 PM, Simon Riggs <simon@2ndquadrant.com> wrote:

> We don't yet have a mechanism for an
> index AM to say "damn, this index is screwed up, don't use it".
>

mark pg_index.indisvalid and/or pg_index.indisready to false in the
hot standby node?

--
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157

pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Preventing index scans for non-recoverable index AMs
Next
From: Kenneth Marshall
Date:
Subject: Re: Preventing index scans for non-recoverable index AMs