Re: postgresql and syslog

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

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