Re: Postgresql backend to perform vacuum automatically

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Postgresql backend to perform vacuum automatically
Дата
Msg-id 200203050153.g251rqW08584@candle.pha.pa.us
обсуждение исходный текст
Ответ на Postgresql backend to perform vacuum automatically  ("Nicolas Bazin" <nbazin@ingenico.com.au>)
Ответы Re: Postgresql backend to perform vacuum automatically  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Nicolas Bazin wrote:
> >From what I read in the recent exchanges in the PostgreSQL vs ORACLE thread it would seem a good idea for the
backendto keep track of the number of update performed on a database and after a certain threshold start a vacuum in a
separateprocess by itself.
 
> Any comments?

Yes, makes sense to me, especially now that we have a nolocking vacuum. 
Tom, do you have any ideas on this?

-- 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 по дате отправления:

Предыдущее
От: Barry Lind
Дата:
Сообщение: Re: JDBC: java.sql.SQLException: results returned
Следующее
От: "Rod Taylor"
Дата:
Сообщение: Dependencies with pg_depends