"Guillaume Smet" <guillaume.smet@xxxxxxxxx> 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
