Re: pgsql: Add the "snapshot too old" feature - Mailing list pgsql-committers

From Andres Freund
Subject Re: pgsql: Add the "snapshot too old" feature
Date
Msg-id 20160412185906.gx6qosdnag2efhgt@alap3.anarazel.de
Whole thread Raw
In response to Re: pgsql: Add the "snapshot too old" feature  (Kevin Grittner <kgrittn@gmail.com>)
List pgsql-committers
On 2016-04-12 13:57:26 -0500, Kevin Grittner wrote:
> I have booked two large NUMA machines for Friday to look for any
> remaining performance regressions on high-concurrency loads on such
> machines.  Anyone with ideas on particular tests that they feel
> should be included, please let me know before then.

The worst case is probably statements which are utterly trivial to
execute, but do require a snapshot both during planning and
execution. Like e.g. SELECT 1;. That's probably a good thing to get
started with.

Greetings,

Andres Freund


pgsql-committers by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: pgsql: Add the "snapshot too old" feature
Next
From: Kevin Grittner
Date:
Subject: Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold <