| 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: | Whole Thread | Raw Message | 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(-)
| 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 < |