Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: disabling an index without deleting it?
- From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
- To: "Markus Bertheau" <mbertheau(dot)pg(at)googlemail(dot)com>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- Cc: "Joshua D. Drake" <jd(at)commandprompt(dot)com>, "Peter Koczan" <pjkoczan(at)gmail(dot)com>, "Scott Marlowe" <scott(dot)marlowe(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 14:50:10 -0600
- Message-id: <47C578A1.EE98.0025.0@wicourts.gov> <text/plain>
>>> On Tue, Feb 26, 2008 at 10:48 PM, in message <13604(dot)1204087729(at)sss(dot)pgh(dot)pa(dot)us>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote: > Er, later than what? Once the DROP is pending, other transactions can > hardly safely use the index for lookups, and what should they do about > insertions? Out of curiosity, couldn't any transaction using a snapshot prior to the commit of the DROP continue to use it (just like an uncommited DELETE of a row)? The transaction doing the DROP wouldn't maintain it for modifications, which is fine whether it is committed or rolled back. There would just be the matter of "vacuuming" the index out of physical existence once all transactions which could see it are gone. That's probably naive, but I'm curious what I'm missing. -Kevin
- Follow-Ups:
- Re: disabling an index without deleting it?
- From: Tom Lane
- Re: disabling an index without deleting it?
- 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
- disabling an index without deleting it?
- Prev by Date: Re: PG planning randomly ?
- Next by Date: Re: disabling an index without deleting it?
- Previous by thread: Re: disabling an index without deleting it?
- Next by thread: Re: disabling an index without deleting it?
- Indexes: