Re: postgresql and syslog - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: postgresql and syslog
Date
Msg-id 20090807195650.GB5290@alvh.no-ip.org
Whole thread Raw
In response to Re: postgresql and syslog  (Michael Nacos <m.nacos@gmail.com>)
List pgsql-performance
Michael Nacos escribió:

> I would be very surprised if logging had a significant overhead any method
> you choose. there's probably something very wrong with your setup if this
> is the case.

Either something very wrong, or the load is extremely high.  In the
latter case perhaps it would make sense to ship syslog to a remote
machine.  Since it uses UDP sockets, it wouldn't block when overloaded
but rather lose messages (besides, it means it has low overhead).

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-performance by date:

Previous
From: Michael Nacos
Date:
Subject: Re: postgresql and syslog
Next
From: Scott Carey
Date:
Subject: Re: SQL select query becomes slow when using limit (with no offset)