Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] syslog slowing the database? - Mailing list pgsql-performance

From Tom Lane
Subject Re: [ADMIN] syslog slowing the database?
Date
Msg-id 370.1078877805@sss.pgh.pa.us
Whole thread Raw
In response to syslog slowing the database?  (Greg Spiegelberg <gspiegelberg@cranel.com>)
Responses Re: [ADMIN] syslog slowing the database?  ("Gavin M. Roy" <gmr@ehpg.net>)
Re: [ADMIN] syslog slowing the database?  (Greg Spiegelberg <gspiegelberg@cranel.com>)
Re: [ADMIN] syslog slowing the database?  ("Magnus Naeslund(t)" <mag@fbab.net>)
List pgsql-performance
Tree view 
Greg Spiegelberg <gspiegelberg@cranel.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

pgsql-performance by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Delete performance on delete from table with inherited
Next
From: Tom Lane
Date:
Subject: Re: Delete performance on delete from table with inherited tables