Exposing some hidden serializable transaction costs

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Exposing some hidden serializable transaction costs
Date: 2025-06-30 23:00:22
Message-ID: 5631918B-A8DE-4216-9733-2F3CE7B82AAA@thebuild.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Browse pgsql-hackers by date

  From Date Subject
Next Message Andres Freund 2025-06-30 23:42:51 Re: [PoC] Federated Authn/z with OAUTHBEARER
Previous Message Daniel Gustafsson 2025-06-30 22:52:49 Re: [PoC] Federated Authn/z with OAUTHBEARER