Re: disabling an index without deleting it? - Mailing list pgsql-performance

From Joshua D. Drake
Subject Re: disabling an index without deleting it?
Date
Msg-id 20080226143738.05d2cb78@commandprompt.com
Whole thread Raw
In response to Re: disabling an index without deleting it?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Tue, 26 Feb 2008 17:22:40 -0500
Tom Lane <tgl@sss.pgh.pa.us> wrote:

> "Joshua D. Drake" <jd@commandprompt.com> writes:
> > "Scott Marlowe" <scott.marlowe@gmail.com> wrote:
> >> begin;
> >> drop index abc_dx;
> >> select ....
> >> rollback;
> >> 
> >> and viola, your index is still there.  note that there are likely
> >> some locking issues with this, so be careful with it in
> >> production.  But on a test box it's a very easy way to test
> >> various indexes.
> 
> > Wouldn't you also bloat the index?
> 
> No, what makes you think that? 

Well now that I am obviously wrong :P. I was thinking about it from the:

BEGIN;
DELETE FROM
ROLLBACK;

Perspective.

Sincerely,

Joshua D. Drake



- -- 
The PostgreSQL Company since 1997: http://www.commandprompt.com/ 
PostgreSQL Community Conference: http://www.postgresqlconference.org/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL SPI Liaison | SPI Director |  PostgreSQL political pundit

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFHxJSyATb/zqfZUUQRAnSPAJkB6Gz0gUTPohXcFak9LbVYIdxCtwCfWvxp
gQZymMaKEXfo2Mf1E2BWtUk=
=p+EO
-----END PGP SIGNATURE-----

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: disabling an index without deleting it?
Next
From: James Mansion
Date:
Subject: Re: LISTEN / NOTIFY performance in 8.3