Re: rotatelog / logrotate with PostgreSQL

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: rotatelog / logrotate with PostgreSQL
Дата
Msg-id 20020926004757.GC5706@svana.org
обсуждение исходный текст
Ответ на Re: rotatelog / logrotate with PostgreSQL  ("scott.marlowe" <scott.marlowe@ihs.com>)
Ответы Re: rotatelog / logrotate with PostgreSQL  ("scott.marlowe" <scott.marlowe@ihs.com>)
Список pgsql-general
On Wed, Sep 25, 2002 at 08:58:22AM -0600, scott.marlowe wrote:
> Well, I've found the syslog facility to be noticeable slower than
> rotatelogs with pgsql doing its own logging.  So that's why I do it the
> rotatelogs way.  Choice is good.

One thing to be careful of is to put a hyphen before the filename in the
syslog config. This will stop syslog doing a sync() after *every* message,
which quite noticably kills performance. Also make sure it's only logging to
the logs you want and not to multiple files.

Hope this helps,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.

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

Предыдущее
От: "Marc G. Fournier"
Дата:
Сообщение: [URGENT] Need large installations of mission critical uses of PgSQL
Следующее
От: Justin Clift
Дата:
Сообщение: Re: [HACKERS] New PostgreSQL Tool available :pg_autotune