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

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: Some thoughts about i/o priorities and throttling vacuum
Дата
Msg-id 20031017135007.GA1089@libertyrms.info
обсуждение исходный текст
Ответ на 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:
> I am slightly confused here. IIRC pg_autovacuum never did a vacuum full. At 
> the most it does vacuum /vacuum analyse, none of which chew disk bandwidth. 

The latter is false.  VACUUM FULL certainly uses _more_ disk
bandwidth than VACUUM, but it's just false that plain VACUUM doesn't
contend for disk.  And if you're already maxed, then that extra
bandwidth you cannot afford.

A


-- 
----
Andrew Sullivan                         204-4141 Yonge Street
Afilias Canada                        Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8                                        +1 416 646 3304
x110



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

Предыдущее
От: Andreas Pflug
Дата:
Сообщение: Re: Mapping Oracle types to PostgreSQL types
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Some more information_schema issues