Re: pg_autovacuum next steps

Поиск
Список
Период
Сортировка
От Alex J. Avriette
Тема Re: pg_autovacuum next steps
Дата
Msg-id 20040323025025.GK25451@posixnap.net
обсуждение исходный текст
Ответ на Re: pg_autovacuum next steps  ("Matthew T. O'Connor" <matthew@zeut.net>)
Список pgsql-hackers
On Mon, Mar 22, 2004 at 04:50:57PM -0500, Matthew T. O'Connor wrote:

> Could you please explain this better, I don't really understand what the 
> problem is.  If you want pg_autovacuum to perform a vacuum on a table 
> that has had exactly X updates no matter what, you can just run it with 
> -V0 -vX (where X is the vacuum threshold)  same thing can be done for 
> analyze.  Are you saying that you did this and it did not work as expected?

My experience was it did not vacuum at all.

> Everyone agrees it should be in the backend eventually the questions 
> were just if it was ready, and how or if it should change when it goes in.

It is very simple code, I'm not sure what is "not ready" about it. If
people don't want to use it, they don't have to. Many databases can go
days to weeks without vacuuming.

alex

--
alex@posixnap.net
Alex J. Avriette, Unix Systems Gladiator
"You cannot invade the mainland United States. There would be a rifle behind each blade of grass." - Admiral Isoroku
Yamamoto
 


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

Предыдущее
От: Christopher Kings-Lynne
Дата:
Сообщение: bug in 7.4 SET WITHOUT OIDs
Следующее
От: "Matthew T. O'Connor"
Дата:
Сообщение: Re: [DEFAULT] Daily digest v1.4346 (20 messages)