Re: How to ENABLE SQL capturing???

Поиск
Список
Период
Сортировка
От Jonathan Ellis
Тема Re: How to ENABLE SQL capturing???
Дата
Msg-id e06563880708130804i5f9277f1pe62e85c6c1e69df@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to ENABLE SQL capturing???  ("Joshua D. Drake" <jd@commandprompt.com>)
Ответы Re: How to ENABLE SQL capturing???  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-performance
On 8/10/07, Joshua D. Drake <jd@commandprompt.com> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> smiley2211 wrote:
> > Jeff,
> >
> > You are CORRECT...my queries were going to /var/log/messages...had to get
> > the Linux Admin to grant me READ access to the file...
>
> You may want to actually get that to stop. Syslog is a notorious
> performance bottleneck for postgresql.

Can you elaborate?  The only reference to this I could find was a
thread from 2004 where someone wasn't rotating his logs.

-Jonathan

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

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: select count(*) performance
Следующее
От: "Relyea, Mike"
Дата:
Сообщение: Re: Help optimize view