Re: Vacuum improvement

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Vacuum improvement
Дата
Msg-id 20811.1034740355@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Vacuum improvement  (Gavin Sherry <swm@linuxworld.com.au>)
Ответы Re: Vacuum improvement  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Список pgsql-hackers
Gavin Sherry <swm@linuxworld.com.au> writes:
> have a parameter which specified how much of the table is vacuumed. That
> is, you could specify:
> VACUUM FULL test 20 precent;

Erm ... but which 20 percent?  In other words, how could you arrange for
repeated applications of such a command to cover the whole table, and
not just retrace an already-cleaned-out portion?

I don't object to the idea in principle, but I am not sure how to
implement it in practice.
        regards, tom lane


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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Changing Column Order (Was Re: MySQL vs PostgreSQL.)
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Vacuum improvement