Re: Database size Vs performance degradation

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: Database size Vs performance degradation
Дата
Msg-id 4890A261.8040802@archonet.com
обсуждение исходный текст
Ответ на Re: Database size Vs performance degradation  ("Dave North" <DNorth@signiant.com>)
Список pgsql-performance
Dave North wrote:
> -----Original Message-----
> From: Richard Huxton [mailto:dev@archonet.com]

>
> Well, that's pretty much the definition of bloat. Are you sure you're
> vacuuming enough?
>
> DN: Well, the auto-vac is kicking off pretty darn frequently...around
> once every 2 minutes.  However, you just made me think of the obvious -
> is it actually doing anything?!  The app is pretty darn write intensive
> so I wonder if it's actually able to vacuum the tables?

If you've got a big batch delete, it can't hurt to manually vacuum that
table immediately afterwards.

--
   Richard Huxton
   Archonet Ltd

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

Предыдущее
От: Mark Roberts
Дата:
Сообщение: Re: Database size Vs performance degradation
Следующее
От: "Dave North"
Дата:
Сообщение: Re: Database size Vs performance degradation