Skip site navigation (1) Skip section navigation (2)

Re: [PERFORM] syslog slowing the database?

From: Stephen Robert Norris <srn(at)commsecure(dot)com(dot)au>
To: "Gavin M(dot) Roy" <gmr(at)ehpg(dot)net>
Cc: PgSQL Performance ML <pgsql-performance(at)postgresql(dot)org>,Postgres Admin List <pgsql-admin(at)postgresql(dot)org>
Subject: Re: [PERFORM] syslog slowing the database?
Date: 2004-03-10 01:32:07
Message-ID: 1078882327.9858.24.camel@chinstrap (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-performance
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(at)fn(dot)com(dot)au
Farrow Norris Pty Ltd	+61 417 243 239


In response to

pgsql-performance by date

Next:From: Marcus Andree S. MagalhaesDate: 2004-03-10 03:35:15
Subject: optimizing large query with IN (...)
Previous:From: Gavin M. RoyDate: 2004-03-10 01:09:13
Subject: Re: [PERFORM] syslog slowing the database?

pgsql-admin by date

Next:From: Bruce MomjianDate: 2004-03-10 02:52:02
Subject: Re: Restricting Groups / Users
Previous:From: Hadley WillanDate: 2004-03-10 01:21:59
Subject: Restricting Groups / Users

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group