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
Ответ на
Список
Дерево обсуждения
[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
Дата:
От: Alvaro Herrera
Дата:
FAQ