Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: disabling an index without deleting it?
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: "Markus Bertheau" <mbertheau(dot)pg(at)googlemail(dot)com>
- Cc: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>, "Joshua D. Drake" <jd(at)commandprompt(dot)com>, "Peter Koczan" <pjkoczan(at)gmail(dot)com>, pgsql-performance <pgsql-performance(at)postgresql(dot)org>
- Subject: Re: disabling an index without deleting it?
- Date: Wed, 27 Feb 2008 00:38:49 -0500
"Markus Bertheau" <mbertheau(dot)pg(at)googlemail(dot)com> writes: > On the other hand, if the only reason to have that feature is to plan > and execute queries pretending that one index doesn't exist, then DROP > INDEX DEFERRED is not the most straightforward syntax. Yeah, I was just about to mention that 8.3 has a hook that allows a plug-in to manipulate the planner's notions of which indexes exist. Ignoring a specific index would be really trivial. regards, tom lane
- References:
- disabling an index without deleting it?
- From: Peter Koczan
- Re: disabling an index without deleting it?
- From: Scott Marlowe
- Re: disabling an index without deleting it?
- From: Joshua D. Drake
- Re: disabling an index without deleting it?
- From: Tom Lane
- Re: disabling an index without deleting it?
- From: Markus Bertheau
- Re: disabling an index without deleting it?
- From: Tom Lane
- Re: disabling an index without deleting it?
- From: Scott Marlowe
- Re: disabling an index without deleting it?
- From: Markus Bertheau
- disabling an index without deleting it?
- Prev by Date: Re: disabling an index without deleting it?
- Next by Date: Re: LISTEN / NOTIFY performance in 8.3
- Previous by thread: Re: disabling an index without deleting it?
- Next by thread: Re: disabling an index without deleting it?
- Indexes: