Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold <

Поиск
Список
Период
Сортировка
Искать
От
Andres Freund
Тема
Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold <
Дата
Msg-id
20160416205630.puxsglckxi3sn5ec@alap3.anarazel.de
Ответ на
Список
Дерево обсуждения
pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < Kevin Grittner <kgrittn@postgresql.org>
Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < Andres Freund <andres@anarazel.de>
Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < Kevin Grittner <kgrittn@gmail.com>
Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < Andres Freund <andres@anarazel.de>
Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < Kevin Grittner <kgrittn@gmail.com>
Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < Andres Freund <andres@anarazel.de>
Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < Kevin Grittner <kgrittn@gmail.com>
Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < Andres Freund <andres@anarazel.de>
Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < Andres Freund <andres@anarazel.de>
Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < Kevin Grittner <kgrittn@gmail.com>
Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < Andres Freund <andres@anarazel.de>
Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < Kevin Grittner <kgrittn@gmail.com>
Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < Andres Freund <andres@anarazel.de>
Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < Andres Freund <andres@anarazel.de>
Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < Andres Freund <andres@anarazel.de>
Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < Kevin Grittner <kgrittn@gmail.com>
Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < Andres Freund <andres@anarazel.de>
Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < Kevin Grittner <kgrittn@gmail.com>
Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < Andres Freund <andres@anarazel.de>
Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < Noah Misch <noah@leadboat.com>
Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < Andres Freund <andres@anarazel.de>
Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < Andres Freund <andres@anarazel.de>
Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < Kevin Grittner <kgrittn@gmail.com>
Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < Kevin Grittner <kgrittn@gmail.com>
Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < David Steele <david@pgmasters.net>
Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < Andres Freund <andres@anarazel.de>
Re: [HACKERS] Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < Kevin Grittner <kgrittn@gmail.com>
On 2016-04-16 16:44:52 -0400, Noah Misch wrote:
> That is more controversial than the potential ~2% regression for
> old_snapshot_threshold=-1.  Alvaro[2] and Robert[3] are okay releasing
> that way, and Andres[4] is not.

FWIW, I could be kinda convinced that it's temporarily ok, if there'd be
a clear proposal on the table how to solve the scalability issue around
MaintainOldSnapshotTimeMapping(). Postponing the optimization around
something as trivial as a spinlock around reading an LSN is one thing,
postponing something we don't know the solution to is anohter.

Andres

В списке pgsql-committers по дате отправления
От: Noah Misch
Дата:
От: Tom Lane
Дата:
FAQ