Re: disabling an index without deleting it?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

On Tue, 26 Feb 2008 14:57:51 -0600
"Scott Marlowe" <scott.marlowe@xxxxxxxxx> 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-----

---------------------------(end of broadcast)---------------------------TIP 7: You can help support the PostgreSQL project by donating at
                http://www.postgresql.org/about/donate

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux