Re: perfromance impact of vacuum

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: perfromance impact of vacuum
Дата
Msg-id 20030715165350.GA12809@wolff.to
обсуждение исходный текст
Ответ на Re: perfromance impact of vacuum  ("Jay O'Connor" <joconnor@cybermesa.com>)
Ответы Re: perfromance impact of vacuum  ("Jay O'Connor" <joconnor@cybermesa.com>)
Re: perfromance impact of vacuum  (Martijn van Oosterhout <kleptog@svana.org>)
Список pgsql-general
On Tue, Jul 15, 2003 at 10:37:28 -0700,
  Jay O'Connor <joconnor@cybermesa.com> wrote:
>
> Just curious but is the length of time to vacuum influenced more by the
> size of the table or the number of dead tuples?

I think the fraction of the table that is dead tuples is probably the best
thing to look at for deciding when to vacuum (unless the tables are very
small in which case checking for the number of blocks used may be better).

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

Предыдущее
От: Dmitry Tkach
Дата:
Сообщение: Re: [BUGS] INSTEAD rule bug?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [BUGS] INSTEAD rule bug?