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

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема pgsql: Mitigate "snapshot too old" performance regression on NUMA
Дата
Msg-id E1ayqnW-0007MZ-BG@gemulon.postgresql.org
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold <
Следующее
От: Stephen Frost
Дата:
Сообщение: pgsql: Disable BLOB test in pg_dump TAP tests