Re: Some thoughts about i/o priorities and throttling vacuum

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Some thoughts about i/o priorities and throttling vacuum
Дата
Msg-id 20031017140605.GA3723@dcc.uchile.cl
обсуждение исходный текст
Ответ на Re: Some thoughts about i/o priorities and throttling vacuum  (Shridhar Daithankar <shridhar_daithankar@persistent.co.in>)
Ответы Re: Some thoughts about i/o priorities and throttling vacuum  (Shridhar Daithankar <shridhar_daithankar@persistent.co.in>)
Список pgsql-hackers
On Fri, Oct 17, 2003 at 07:04:45PM +0530, Shridhar Daithankar wrote:

> And if pg_autovacuum is running along with postmaster all the time, with 
> aggressive polling like 5 sec, the database should not accumulate any dead 
> tuples nor it would suffer xid wraparound as there are vacuum happening 
> constantly.

The database can suffer XID wraparound anyway if there's at least one
table without updates, because the autovacuum daemon will never vacuum
it (correct me if I'm wrong).

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Tiene valor aquel que admite que es un cobarde" (Fernandel)


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Mapping Oracle types to PostgreSQL types
Следующее
От: Shridhar Daithankar
Дата:
Сообщение: Re: Some thoughts about i/o priorities and throttling vacuum