"Phoenix Kiula" <phoenix.kiula@xxxxxxxxx> writes: > Thank you so much! My only concern, probably a hangover from the MySQL > world, is that if I have 5 of 6 indices, what would that do to INSERT > and UPDATE performance if all these indices have to be updated? Is > updating individual indices faster than one large compound index? Probably slower, but the compound index is enough more specialized that it's not as useful as the individual indexes. (I suspect that that compound index in MySQL didn't do you nearly as much good as you thought, either.) You should read http://www.postgresql.org/docs/8.2/static/indexes-bitmap-scans.html and nearby sections of the manual. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
