-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Tue, 26 Feb 2008 17:22:40 -0500 Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > "Joshua D. Drake" <jd@xxxxxxxxxxxxxxxxx> writes: > > "Scott Marlowe" <scott.marlowe@xxxxxxxxx> 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----- ---------------------------(end of broadcast)---------------------------TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
