Re: rotatelog / logrotate with PostgreSQL

Поиск
Список
Период
Сортировка
От scott.marlowe
Тема Re: rotatelog / logrotate with PostgreSQL
Дата
Msg-id Pine.LNX.4.33.0209260837470.26236-100000@css120.ihs.com
обсуждение исходный текст
Ответ на Re: rotatelog / logrotate with PostgreSQL  (Martijn van Oosterhout <kleptog@svana.org>)
Список pgsql-general
On Thu, 26 Sep 2002, Martijn van Oosterhout wrote:

> 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.

Thanks, I'll try that.


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Performance while loading data and indexing
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Adding "on delete cascade" after table creation ?