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

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: Performance hit if I create multiple DBs on same instance
Дата
Msg-id 79e102bcb98a7af48924f427512a502108408b5d.camel@cybertec.at
обсуждение исходный текст
Ответ на Re: Performance hit if I create multiple DBs on same instance  (Ron <ronljohnsonjr@gmail.com>)
Ответы Re: Performance hit if I create multiple DBs on same instance  (Ron <ronljohnsonjr@gmail.com>)
Re: Performance hit if I create multiple DBs on same instance  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-general
Дерево обсуждения 
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.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com

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

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: archive file "00000001000000000000006F" has wrong size: 67118648 instead of 16777216
Следующее
От: Hagen Finley
Дата:
Сообщение: Re: INSERT Trigger to check for existing records : Does this do what I hope it is doing?