On 8/06/2011 12:19 PM, bakkiya wrote:
We have a postgresql 8.3.8 DB which consumes 100% of the CPU whenever we run any query.
Yep, that's what it's supposed to do if it's not I/O limited. What's the problem? Is the query taking longer than you think it should to execute? Do you expect it to be waiting for disk rather than CPU?
Please show your problem query/queries, and EXPLAIN ANALYZE output. See: http://wiki.postgresql.org/wiki/Guide_to_reporting_problems
http://postgresql.1045698.n5.nabble.com/file/n4465765/untitled.bmp
Heh. That's been resized to a 250x250 bitmap, which isn't exactly useful or readable.
Why not paste the text rather than a screenshot? -- Craig Ringer Tech-related writing at http://soapyfrogs.blogspot.com/ -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
