Re: Performance hit if I create multiple DBs on same instance

Поиск
Список
Период
Сортировка
От Ron
Тема Re: Performance hit if I create multiple DBs on same instance
Дата
Msg-id e9b556a7-e05d-277b-0e62-87472e2c0f29@gmail.com
обсуждение исходный текст
Ответ на Re: Performance hit if I create multiple DBs on same instance  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-general
Дерево обсуждения 
On 11/25/20 8:59 AM, Laurenz Albe wrote:
> On Tue, 2020-11-24 at 11:34 -0600, Ron wrote:
>> And if you're afraid of autovacuum and autoanalyze stealing resources, then disable them (at the table level).
> Ugh, bad advice.
>
> Better would be to VACUUM (FREEZE) these static table once, then autovacuum
> won't ever perform resource consuming activities on them again.

Good to know.

-- 
Angular momentum makes the world go 'round.

В списке pgsql-general по дате отправления:

Предыдущее
От: Hagen Finley
Дата:
Сообщение: Re: INSERT Trigger to check for existing records : Does this do what I hope it is doing?
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: INSERT Trigger to check for existing records : Does this do what I hope it is doing?