"Peter Bauer" <peter.m.bauer@gmail.com> writes:
> yes, there are about 10 postmaster processes in top which eat up all
> of the CPU cycles at equal parts.
What are these processes doing exactly --- can you show us the queries
they're executing? It might be worth attaching to a few of them with
gdb to get stack traces, to see if there's any commonality about the
traces:
$ gdb /path/to/postgres PID-of-backend
gdb> bt
gdb> quit
are you sure? y
$ <repeat with other backends, and/or same backend after a few sec>
regards, tom lane