Temporarily “Dropping” a PostgreSQL Index
Tuesday, December 5th, 2006 @ 2:45 pm
| PostgreSQL
> BTW, the cute way to do that is > BEGIN; > DROP INDEX unwanted; > EXPLAIN ANALYZE whatever...; > ROLLBACK; > > No need to actually rebuild the index when you are done. > > This does hold an exclusive lock on the table for the duration of your > experiment, so maybe not such a good idea in a live environment ... but > then again, dropping useful indexes in a live environment isn't a good > idea either, and this at least reduces the duration of the experiment by > a good deal.
I found this comment by Tom Lane in the Postgresql mailing list archive yesterday. A pretty nifty trick, and perhaps something useful for inclusion in a university syllabus?
Recently
December 8th, 2006 at 9:36 pm
*couldn’t find a tagboard.. if one exists…>.>* whadda expect? i have to move a bunch.. i can’t just make it easy for people to find and read about the sorrdid (sp?) affair that is moi life… *fancy wave sniffle thing* ~.^ yeah yeah.. but you moved too! *points accusingly* and a few monthes?? ~.- heheheh… whatever… hope you’re doing okay and such wonderful dull things… and…. *shifty eyes* … *glomp* hehehe… i win! ~^