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
Дата: