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

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not

Reply via email to