Re: Re[2]: [PERFORM] SMP on a heavy loaded database - Mailing list pgsql-performance

From Claudio Freire
Subject Re: Re[2]: [PERFORM] SMP on a heavy loaded database
Date
Msg-id CAGTBQpZBZgoenkgtKhW=KN082rpa+PDFAh9bW9241kJZr3qNYw@mail.gmail.com
Whole thread Raw
In response to Re[2]: [PERFORM] Re[2]: [PERFORM] SMP on a heavy loaded database  (nobody nowhere <devnull@mail.ua>)
List 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 by date:

Previous
From: nobody nowhere
Date:
Subject: Re[2]: [PERFORM] Re[2]: [PERFORM] SMP on a heavy loaded database
Next
From: dankogan
Date:
Subject: Re: Postgres delete performance problem