Exposing some hidden serializable transaction costs - Mailing list pgsql-hackers

From Christophe Pettus
Subject Exposing some hidden serializable transaction costs
Date
Msg-id 5631918B-A8DE-4216-9733-2F3CE7B82AAA@thebuild.com
Whole thread Raw
List pgsql-hackers
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? 


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Sanding down some edge cases for PL/pgSQL reserved words
Next
From: Andres Freund
Date:
Subject: Re: [PoC] Federated Authn/z with OAUTHBEARER