David Rees wrote:
You need to find out what all those Postgres processes are doing. You might try enabling update_process_title and then using ps to figure out what each instance is using.
That's what the addition of "-c" to top I suggested does on Linux; it shows the updated process titles where the command line is in the default config.
-- Greg Smith 2ndQuadrant US Baltimore, MD PostgreSQL Training, Services and Support greg@xxxxxxxxxxxxxxx www.2ndQuadrant.us -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance