Re: Recycled Log Files

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Recycled Log Files
Дата
Msg-id 12208.1076100723@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Recycled Log Files  (Naomi Walker <nwalker@eldocomp.com>)
Список pgsql-admin
Naomi Walker <nwalker@eldocomp.com> writes:
> We are running Postgres 7.3.4 on Solaris 6 on an E3500.  I noticed the
> following messages, and attempted to remedy the situation by upping our
> wal_buffers to 64, thinking we might need more room.

> 2004-02-05 16:48:16 LOG:  recycled transaction log file 0000000600000029
> 2004-02-05 16:48:27 LOG:  recycled transaction log file 000000060000002A
> 2004-02-05 16:48:27 LOG:  recycled transaction log file 000000060000002B

This is normal operation.  I'm not sure why we have it as LOG level and
not DEBUG-something.  I suppose the messages are slightly useful to give
an idea of how fast you are using up log segments, but now that
wal_files isn't a separately tweakable parameter it's not obvious why
the average DBA would care.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: FATAL 2: (pg_clog ... no such file or directory)
Следующее
От: "scott.marlowe"
Дата:
Сообщение: Re: Problem with too short column