On Fri, Jan 4, 2013 at 11:41 AM, nobody nowhere <devnull@xxxxxxx> wrote: > So how many concurrent users are accessing this db? pgsql assigns one > process on one core so to speak. It can't spread load for one user > over all cores. > > 64 php Fast-cgi processes over the Unix socket and about 20-30 over tcp I guess that means the server isn't dedicated to postgres... ...have you checked which PID is using that core? Is it postgres-related? -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance