-----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
