"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