Re: [ADMIN] syslog slowing the database?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [ADMIN] syslog slowing the database?
Дата
Msg-id 370.1078877805@sss.pgh.pa.us
обсуждение исходный текст
Ответ на syslog slowing the database?  (Greg Spiegelberg <gspiegelberg@cranel.com>)
Ответы 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>)
Список pgsql-performance
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 по дате отправления:

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: Delete performance on delete from table with inherited
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Delete performance on delete from table with inherited tables