Re: cheaper snapshots redux - Mailing list pgsql-hackers

From Tom Lane
Subject Re: cheaper snapshots redux
Date
Msg-id 2294.1314284377@sss.pgh.pa.us
Whole thread Raw
In response to Re: cheaper snapshots redux  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: cheaper snapshots redux
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> Well, one long-running transaction that only has a single XID is not
> really a problem: the snapshot is still small.  But one very old
> transaction that also happens to have a large number of
> subtransactions all of which have XIDs assigned might be a good way to
> stress the system.

That's a good point.  If the ring buffer size creates a constraint on
the maximum number of sub-XIDs per transaction, you're going to need a
fallback path of some sort.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: cheaper snapshots redux
Next
From: Markus Wanner
Date:
Subject: Re: cheaper snapshots redux