Re: PostgreSQL and Xeon MP

"Guillaume Smet" <guillaume.smet@gmail.com> writes:
> You mean strace -p pid with pid on some of the postgres process not on
> the postmaster itself, does you?

Right, pick a couple that are accumulating CPU time.

> Do we need other options?

strace will generate a *whole lot* of output to stderr.  I usually do
something like
    strace -p pid 2>outfile
and then control-C it after a few seconds.

> Which pattern should we expect?

What we want to find out is if there's a lot of select()s and/or
semop()s shown in the result.  Ideally there wouldn't be any, but
I fear that's not what you'll find.

            regards, tom lane