Re: Postgresql backend to perform vacuum automatically

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Postgresql backend to perform vacuum automatically
Дата
Msg-id 200203050605.g25656c20570@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: Postgresql backend to perform vacuum automatically  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Список pgsql-hackers
> vacuum_idle_threshold
> = system load below which the system must be before a vacuum can be
> performed.  0 = no requirement
> 
> vacuum_time_threshold
> = seconds since last vacuum before which another vacuum cannot occur. 0 = no
> requirement.
> 
> If all 3 are 0, then no auto-vacuuming is performed at all.  There's
> probably trouble if only the idle threshold is set to zero.
> 
> And the same for the 'analyze' command?
> 
> If they want it on a per-table basis, then they can just do it themselves
> with a cronjob!

Yes, and Jan's statistics stuff has stats on table activity.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


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

Предыдущее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Re: Postgresql backend to perform vacuum automatically
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Please, apply patch for contrib/tsearch