От: George Sexton
Тема: AutoVacuum_NapTime
Дата: ,
Msg-id: 053401cab291$a8cf7250$fa6e56f0$@com
(см: обсуждение, исходный текст)
Ответы: Re: AutoVacuum_NapTime  (Tom Lane)
Список: pgsql-performance

Скрыть дерево обсуждения

AutoVacuum_NapTime  ("George Sexton", )
 Re: AutoVacuum_NapTime  (Tom Lane, )
  Re: AutoVacuum_NapTime  ("George Sexton", )
   Re: AutoVacuum_NapTime  (Alvaro Herrera, )

I have a system with around 330 databases running PostgreSQL 8.4.2

What would the expected behavior be with AutoVacuum_NapTime set to the
default of 1m and autovacuum_workers set to 3?

What I'm observing is that the system is continuously vacuuming databases.
Would these settings mean the autovacuum worker would try to vacuum all 330
databases once per minute?

George Sexton

В списке pgsql-performance по дате сообщения:

От: "terry"
Сообщение: Re: can we optimize STACK_DEPTH_SLOP
От: Scott Carey
Сообщение: Re: SSD + RAID