Hi,

On Tue, Nov 17, 2026 at 1:32 PM surya poondla <[email protected]> wrote:
>
> One thing I'd like to keep from v10 is the xid column.  In v11 a backend
> row's xmin is the older of its xid and xmin, so a backend that owns the
> oldest xid and backends that merely took snapshots after it look the
> same.  With one idle-in-transaction session and twenty readers whose
> xmin equals its xid, that's twenty-one identical rows, and only one of
> them is worth terminating.

I would like the p_x_h view to report what goes into computing the
xmin horizon (in this case, the older of the txn's xmin and xid). And,
users need to look at one of the existing views depending on the
blocker type (p_s_a, p_r_s, p_s_r_s, or p_p_x) to find out what
exactly the blocker is doing, and then decide. I don't think we can
avoid that, otherwise we would end up duplicating many of the columns
from existing views in the p_x_h view, which I don't think is a great
idea.

--
Bharath Rupireddy
Amazon Web Services: https://aws.amazon.com


Reply via email to