On Wed, Jun 8, 2011 at 07:19, bakkiya <bakkiya@xxxxxxxxx> wrote: > We have a postgresql 8.3.8 DB which consumes 100% of the CPU whenever we run > any query. We got vmstat output Machine details are below: Any query? Does even "SELECT 1" not work? Or "SELECT * FROM sometable LIMIT 1" Or are you having problems with only certain kinds of queries? If so, please follow this for how to report it: https://wiki.postgresql.org/wiki/SlowQueryQuestions Regards, Marti -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
