Re: PostgreSQL and Xeon MP - Mailing list pgsql-performance

From Guillaume Smet
Subject Re: PostgreSQL and Xeon MP
Date
Msg-id 1d4e0c10603160808y6c2f683csb74086b10c3cd40e@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL and Xeon MP  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: PostgreSQL and Xeon MP
List pgsql-performance
On 3/16/06, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Can you try strace'ing some of the backend processes while the system is
> behaving like this?  I suspect what you'll find is a whole lot of
> delaying select() calls due to high contention for spinlocks ...

Tom,

I think we can try to do it.

You mean strace -p pid with pid on some of the postgres process not on
the postmaster itself, does you? Do we need other options?
Which pattern should we expect? I'm not really familiar with strace
and its output.

Thanks for your help.

pgsql-performance by date:

Previous
From: "Guillaume Smet"
Date:
Subject: Re: PostgreSQL and Xeon MP
Next
From: Tom Lane
Date:
Subject: Re: PostgreSQL and Xeon MP