Re: disabling an index without deleting it?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Tue, 26 Feb 2008 14:57:51 -0600
"Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> wrote:

> The brick to the head method would use set enable_indexscan = off;
> However, you can delete an index without actually deleting it like so:
>
> 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?

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)

iD8DBQFHxH6rATb/zqfZUUQRAp//AJ4wKiA4WRprp3L3y9UEAzz2rb2+hACaA9b7
A1k3n6GkyFwx2vrbnpD8CX0=
=zYaI
-----END PGP SIGNATURE-----