pgsql: Mitigate "snapshot too old" performance regression on NUMA

From: Kevin Grittner <kgrittn(at)postgresql(dot)org>
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Mitigate "snapshot too old" performance regression on NUMA
Date: 2016-05-07 01:12:46
Message-ID: E1ayqnW-0007MZ-BG@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Mitigate "snapshot too old" performance regression on NUMA

Limit maintenance of time to xid mapping to once per minute. At
least in the tested case this brings performance within 5% of when
the feature is off, compared to several times slower without this
patch.

While there, fix comments and whitespace.

Ants Aasma, with cosmetic adjustments suggested by Andres Freund
Reviewed by Kevin Grittner and Andres Freund

Branch
------
master

Details
-------
http://git.postgresql.org/pg/commitdiff/7e3da1c4737fd6582e12c80983987e4d2cbc1d17

Modified Files
--------------
src/backend/utils/time/snapmgr.c | 85 +++++++++++++++++++++++++++++-----------
1 file changed, 62 insertions(+), 23 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Stephen Frost 2016-05-07 01:24:37 pgsql: Disable BLOB test in pg_dump TAP tests
Previous Message Andres Freund 2016-05-07 00:48:44 Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold <