Thread: Exposing some hidden serializable transaction costs

Exposing some hidden serializable transaction costs

From
Christophe Pettus
Date:
Serialized transactions have a cost that is currently not accounted for in planning time: Rows that are retrieved to be
filteredby a query get SIReadLocks.  This can made an otherwise-good query plan problematic, since it contributes to
querycancellations.  Would it be appropriate to add some kind of cost constant to filtered rows to reflect that?