Re: [PERFORM] syslog slowing the database?

Поиск
Список
Период
Сортировка
От Stephen Robert Norris
Тема Re: [PERFORM] syslog slowing the database?
Дата
Msg-id 1078882327.9858.24.camel@chinstrap
обсуждение исходный текст
Ответ на Re: [PERFORM] syslog slowing the database?  ("Gavin M. Roy" <gmr@ehpg.net>)
Список pgsql-admin
On Wed, 2004-03-10 at 12:09, Gavin M. Roy wrote:
> Might want to look at metalog, it does delayed writes, though ultimately
> your issue is io bound and there's not much you can do to reduce io if
> you want to keep syslog logging your pgsql queries and such.

Yeah, but syslog with fsync() after each line is much, much worse than
syslog without it, assuming anything else is on the same disk (array).
It just guarantees to screw up your drive head movements...

--
Stephen Norris      srn@fn.com.au
Farrow Norris Pty Ltd    +61 417 243 239


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

Предыдущее
От: "Magnus Naeslund(t)"
Дата:
Сообщение: Re: [PERFORM] syslog slowing the database?
Следующее
От: Bart McFarling
Дата:
Сообщение: History Tables Vs History Field