Re: Re[2]: [PERFORM] SMP on a heavy loaded database

Поиск
Список
Период
Сортировка
От Claudio Freire
Тема Re: Re[2]: [PERFORM] SMP on a heavy loaded database
Дата
Msg-id CAGTBQpZBZgoenkgtKhW=KN082rpa+PDFAh9bW9241kJZr3qNYw@mail.gmail.com
обсуждение исходный текст
Ответ на Re[2]: [PERFORM] Re[2]: [PERFORM] SMP on a heavy loaded database  (nobody nowhere <devnull@mail.ua>)
Список pgsql-performance
On Fri, Jan 4, 2013 at 1:23 PM, nobody nowhere <devnull@mail.ua> wrote:
>
> ...have you checked which PID is using that core? Is it postgres-related?
>
> How do I know it?

An unfiltered top or ps might give you a clue. You could also try
iotop, php does hit the filesystem (sessions stored in disk), and if
it's on the same partition as postgres, postgres' fsyncs might cause
it to flush to disk quite heavily.


В списке pgsql-performance по дате отправления:

Предыдущее
От: nobody nowhere
Дата:
Сообщение: Re[2]: [PERFORM] Re[2]: [PERFORM] SMP on a heavy loaded database
Следующее
От: dankogan
Дата:
Сообщение: Re: Postgres delete performance problem