On Tue, Sep 7, 2010 at 8:48 AM, Henk van Lingen <h.g.k.vanlin...@uu.nl> wrote: > > Thanks for your answer. Dropping the (pkey) index is not an option. > iostat suggest the thing is CPU bound (%iowait remaining 11% but cpu > rizing from 1 to 13 %)
How man cores that server have? If you've got 8 cores and one IO bound on this query it'll hit 12%.. IOBound. rely on iostat -xd instead. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
