Re: pg 8.1.2 performance issue

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg 8.1.2 performance issue
Дата
Msg-id 26496.1143389698@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg 8.1.2 performance issue  ("Ed L." <pgsql@bluepolka.net>)
Ответы Re: pg 8.1.2 performance issue  ("Ed L." <pgsql@bluepolka.net>)
Re: pg 8.1.2 performance issue  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-general
"Ed L." <pgsql@bluepolka.net> writes:
> With our set of 4 DBs, that amounts to once every 40 minutes for
> the given database.  I see "LOG:  autovacuum: processing
> database "xyz"" in the log, but I do not see any analyze/vacuum
> commands being issued at all (does it log when it
> analyzes/vacuums?).

Not at the default logging level --- I think you have to go to DEBUG1
or DEBUG2 to get info about per-table actions.  (This ought to be
rethought, likely, as that will also clutter your log with a ton of
extraneous info...)

            regards, tom lane

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

Предыдущее
От: "Ed L."
Дата:
Сообщение: Re: pg 8.1.2 performance issue
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg 8.1.2 performance issue