Re: syslog slowing the database?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Greg Spiegelberg <gspiegelberg(at)cranel(dot)com>
Cc: PgSQL Performance ML <pgsql-performance(at)postgresql(dot)org>, Postgres Admin List <pgsql-admin(at)postgresql(dot)org>
Subject: Re: syslog slowing the database?
Date: 2004-03-10 00:16:45
Message-ID: 370.1078877805@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-performance

Greg Spiegelberg <gspiegelberg(at)cranel(dot)com> writes:
> I turned syslog back on and the restore slowed down again. Turned
> it off and it sped right back up.

We have heard reports before of syslog being quite slow. What platform
are you on exactly? Does Richard's suggestion of turning off syslog's
fsync help?

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2004-03-10 00:25:30 Re: migration from postgresql-7.2. to 7.4.1 : invalid command \n
Previous Message Naomi Walker 2004-03-09 23:44:11 Re: Cygwin - Cygnus for Windows - Linux based portedto Windows

Browse pgsql-performance by date

  From Date Subject
Next Message Stephan Szabo 2004-03-10 00:18:22 Re: Delete performance on delete from table with inherited
Previous Message Tom Lane 2004-03-10 00:07:17 Re: Delete performance on delete from table with inherited tables