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

From: Claudio Freire <klaussfreire(at)gmail(dot)com>
To: nobody nowhere <devnull(at)mail(dot)ua>
Cc: postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Re[2]: [PERFORM] SMP on a heavy loaded database
Date: 2013-01-04 16:43:16
Message-ID: CAGTBQpZBZgoenkgtKhW=KN082rpa+PDFAh9bW9241kJZr3qNYw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, Jan 4, 2013 at 1:23 PM, nobody nowhere <devnull(at)mail(dot)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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message dankogan 2013-01-04 17:49:59 Re: Postgres delete performance problem
Previous Message nobody nowhere 2013-01-04 16:23:46 Re[2]: [PERFORM] Re[2]: [PERFORM] SMP on a heavy loaded database