Re: analyze

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: analyze
Дата
Msg-id dcc563d10801291036g1a24c63dy73756bd24ac69522@mail.gmail.com
обсуждение исходный текст
Ответ на analyze  (Adrian Moisey <adrian@careerjunction.co.za>)
Список pgsql-performance
On Jan 29, 2008 8:28 AM, Adrian Moisey <adrian@careerjunction.co.za> wrote:
> Hi
>
> How long is a piece of string?
>
> While we're at it, how often do I vacuum analyze?
>
> Seriously though, how do I try measure this?

1: Turn on autovacuum.
2: Look up the thread on nagios plugins for pgsql and rip the query
for checking bloat out of it, or alternatively, use NAGIOS I guess. :)

monitor your db for bloat, and if autovacuum isn't keeping up either
set it to be more aggresive, or schedule manual vacuums for the tables
that need it.

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

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: analyze
Следующее
От: "Mike Smith"
Дата:
Сообщение: Re: 8x2.5" or 6x3.5" disks