Re: degenerate performance on one server of 3

Список
Период
Сортировка
От Tom Lane
Тема Re: degenerate performance on one server of 3
Дата
Msg-id 16593.1243865172@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: degenerate performance on one server of 3  (Erik Aronesty)
Ответы Re: degenerate performance on one server of 3  (Erik Aronesty)
Список pgsql-performance
Дерево обсуждения
degenerate performance on one server of 3  (Erik Aronesty, )
 Re: degenerate performance on one server of 3  (Tom Lane, )
  Re: degenerate performance on one server of 3  (Craig Ringer, )
   Re: degenerate performance on one server of 3  (Tom Lane, )
    Re: degenerate performance on one server of 3  (Erik Aronesty, )
     Re: degenerate performance on one server of 3  (Tom Lane, )
      Re: degenerate performance on one server of 3  (Erik Aronesty, )
       Re: degenerate performance on one server of 3  (Tom Lane, )
       Re: degenerate performance on one server of 3  (Reid Thompson, )
        Re: degenerate performance on one server of 3  (Erik Aronesty, )
         Re: degenerate performance on one server of 3  (Robert Haas, )
          Re: degenerate performance on one server of 3  (Scott Carey, )
         Re: degenerate performance on one server of 3  (Scott Carey, )
          Re: degenerate performance on one server of 3  (Erik Aronesty, )
         Re: degenerate performance on one server of 3  (Robert Haas, )
Erik Aronesty <> writes:
> but why wasn't autovac enough to reclaim at least *most* of the space?

Autovac isn't meant to reclaim major amounts of bloat; it's more in the
line of trying to prevent it from happening in the first place.  To
reclaim bloat it would have to execute VACUUM FULL, or some other
operation that requires exclusive table lock, which doesn't seem like
a good idea for an automatic background operation.

            regards, tom lane

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

Предыдущее
От: Scott Carey
Дата:
Сообщение: Re: Scalability in postgres
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Unexpected query plan results