Re: Protect syscache from bloating with negative cache entries
От
Tom Lane
Тема
Re: Protect syscache from bloating with negative cache entries
Дата
Msg-id
16829.1548341992@sss.pgh.pa.us
Ответ на
Re: Protect syscache from bloating with negative cache entries (Bruce Momjian)
Список
Дерево обсуждения
[HACKERS] Protect syscache from bloating with negative cache entries Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: [HACKERS] Protect syscache from bloating with negative cache entries Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Protect syscache from bloating with negative cache entries Craig Ringer <craig@2ndquadrant.com>
Re: [HACKERS] Protect syscache from bloating with negative cache entries Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Protect syscache from bloating with negative cache entries Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Protect syscache from bloating with negative cache entries Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Protect syscache from bloating with negative cacheentries Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: [HACKERS] Protect syscache from bloating with negative cacheentries Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: [HACKERS] Protect syscache from bloating with negative cacheentries Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: [HACKERS] Protect syscache from bloating with negative cache entries Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Protect syscache from bloating with negative cacheentries Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: [HACKERS] Protect syscache from bloating with negative cacheentries Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: [HACKERS] Protect syscache from bloating with negative cache entries Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Protect syscache from bloating with negative cacheentries Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: [HACKERS] Protect syscache from bloating with negative cacheentries Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: [HACKERS] Protect syscache from bloating with negative cacheentries Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: [HACKERS] Protect syscache from bloating with negative cacheentries Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: [HACKERS] Protect syscache from bloating with negative cacheentries Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] Protect syscache from bloating with negative cacheentries Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: [HACKERS] Protect syscache from bloating with negative cache entries Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Protect syscache from bloating with negative cacheentries Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: [HACKERS] Protect syscache from bloating with negative cache entries Thomas Munro <thomas.munro@enterprisedb.com>
Re: [HACKERS] Protect syscache from bloating with negative cacheentries Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: [HACKERS] Protect syscache from bloating with negative cache entries Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] Protect syscache from bloating with negative cacheentries Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: [HACKERS] Protect syscache from bloating with negative cache entries David Steele <david@pgmasters.net>
Re: [HACKERS] Protect syscache from bloating with negative cache entries David Steele <david@pgmasters.net>
Re: [HACKERS] Protect syscache from bloating with negative cache entries Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: [HACKERS] Protect syscache from bloating with negative cache entries Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
Re: Protect syscache from bloating with negative cache entries Michael Paquier <michael.paquier@gmail.com>
Re: Protect syscache from bloating with negative cache entries Robert Haas <robertmhaas@gmail.com>
Re: Protect syscache from bloating with negative cache entries Michael Paquier <michael.paquier@gmail.com>
Re: Protect syscache from bloating with negative cache entries Tom Lane <tgl@sss.pgh.pa.us>
Re: Protect syscache from bloating with negative cache entries Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Protect syscache from bloating with negative cache entries Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Protect syscache from bloating with negative cache entries Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] Protect syscache from bloating with negative cache entries Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Protect syscache from bloating with negative cache entries Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Protect syscache from bloating with negative cache entries Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] Protect syscache from bloating with negative cache entries Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Protect syscache from bloating with negative cacheentries Andres Freund <andres@anarazel.de>
Re: [HACKERS] Protect syscache from bloating with negative cacheentries Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: [HACKERS] Protect syscache from bloating with negative cache entries Michael Paquier <michael.paquier@gmail.com>
Bruce Momjian writes: > On Thu, Jan 24, 2019 at 06:39:24PM +0900, Kyotaro HORIGUCHI wrote: >> I also thought that there's some other features that is useful if >> it could be turned on remotely so the remote GUC feature but it >> was too complex... > Well, I am thinking if we want to do something like this, we should do > it for all GUCs, not just for this one, so I suggest we not do this now > either. I will argue hard that we should not do it at all, ever. There is already a mechanism for broadcasting global GUC changes: apply them to postgresql.conf (or use ALTER SYSTEM) and SIGHUP. I do not think we need something that can remotely change a GUC's value in just one session. The potential for bugs, misuse, and just plain confusion is enormous, and the advantage seems minimal. regards, tom lane
В списке pgsql-hackers по дате отправления
От: Bruce Momjian
Дата: