Re: postgresql and syslog

Список
Период
Сортировка
От Alvaro Herrera
Тема Re: postgresql and syslog
Дата
Msg-id 20090807195650.GB5290@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: postgresql and syslog  (Michael Nacos)
Список pgsql-performance
Дерево обсуждения
postgresql and syslog  (Ibrahim Harrani, )
 Re: postgresql and syslog  (Robert Haas, )
  Re: postgresql and syslog  (Michael Nacos, )
   Re: postgresql and syslog  (Alvaro Herrera, )
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 по дате отправления:

Предыдущее
От: Michael Nacos
Дата:
Сообщение: Re: postgresql and syslog
Следующее
От: Scott Carey
Дата:
Сообщение: Re: SQL select query becomes slow when using limit (with no offset)