pgsql: Mitigate "snapshot too old" performance regression on NUMA - Mailing list pgsql-committers

From Kevin Grittner
Subject pgsql: Mitigate "snapshot too old" performance regression on NUMA
Date
Msg-id E1ayqnW-0007MZ-BG@gemulon.postgresql.org
Whole thread Raw
List 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(-)


pgsql-committers by date:

Previous
From: Andres Freund
Date:
Subject: Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold <
Next
From: Stephen Frost
Date:
Subject: pgsql: Disable BLOB test in pg_dump TAP tests