On Fri, 2007-02-09 at 10:17 -0500, Tom Lane wrote: > Teodor Sigaev <[EMAIL PROTECTED]> writes: > >> Implementing the "replace these TIDs" operation atomically would be > >> simple, except for the new bitmap index am. It should be possible there > > > That isn't simple (may be, even possible) from GIN. > > I suspect that those pushing this idea only care about btrees anyway, > so one possible answer is that HOT is only possible when the table has > only btree indexes --- or at least, only indexes of AMs that support the > replace-these-TIDs operation. (Yet another pg_am flag...)
Well, thats me. Yes, I think b-trees-only is acceptable. Realistically, very frequent updating and full text indexing are easily separable use cases, at least into separate tables. HOT should be of use in Data Warehousing applications also, when summary tables are maintained alongside detailed data, but that also sounds like HOT and bitmap indexes would be separable at the table level without difficulty. -- Simon Riggs EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings