Re: Invisible Indexes - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Invisible Indexes
Date
Msg-id 20180619201740.h5e5nkiuoqan7o5e@alap3.anarazel.de
Whole thread Raw
In response to Re: Invisible Indexes  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Hi,

On 2018-06-19 14:05:24 -0400, Robert Haas wrote:
> Yeah, I agree that a GUC seems more powerful and easier to roll out.
> A downside is that there could be cached plans still using that old
> index.  If we did DDL on the index we could be sure they all got
> invalidated, but otherwise how do we know?

Hm - it doesn't seem too hard to force an invalidation after SIGHUP and
certain config changes. Seems like that would be a good idea for other
existing GUCs anyway?

Greetings,

Andres Freund


pgsql-hackers by date:

Previous
From: Matheus de Oliveira
Date:
Subject: Re: found xmin from before relfrozenxid on pg_catalog.pg_authid
Next
From: Andres Freund
Date:
Subject: Re: found xmin from before relfrozenxid on pg_catalog.pg_authid