Vacuuming and already vacuumed table?

Поиск
Список
Период
Сортировка
От Stephen Frost
Тема Vacuuming and already vacuumed table?
Дата
Msg-id 20030828205301.GZ13329@ns.snowman.net
обсуждение исходный текст
Ответы Re: Vacuuming and already vacuumed table?
Список pgsql-general
Greetings,

  Would it make sense for vacuum to keep a list of 'last vacuumed' or
  similar so that it doesn't vacuum a table which hasn't changed since
  the last time it was vacuum'd?  Seems to me that would be a pretty
  simple optimization which would help out alot on systems which have
  both a large set of tables which are relatively static and data which
  changes a great deal.  This is especially true for vacuum full which
  also locks the table.

  Thoughts?

      Thanks,

        Stephen

Вложения

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

Предыдущее
От: "Nigel J. Andrews"
Дата:
Сообщение: Re: Let's see if this helps ... more anti-virus/anti-spam
Следующее
От: Tom Lane
Дата:
Сообщение: Re: left outer join terrible slow compared to inner join