100% CPU Utilization when we run queries.

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:

# /usr/bin/lscpu
Architecture:          x86_64
CPU(s):                2
Thread(s) per core:    1
Core(s) per socket:    1
CPU socket(s):         2
NUM node(s):          1
Vendor ID:             GenuineIntel
CPU family:            6
Model:                 26
Stepping:              4
CPU MHz:               2666.761
L1d cache:             32K
L1i cache:             32K
L2 cache:              256K
L3 cache:              12288K

Memory:      Total        Used        Free      Shared     Buffers
Cached
Mem:       3928240     3889552       38688           0       26992
2517012
Swap:      2097144      312208     1784936

# /bin/uname -a
Linux wdhsen01 2.6.32.12-0.7-default #1 SMP 2010-05-20 11:14:20 +0200 x86_64
x86_64 x86_64 GNU/Linux .
Postgresql Memory parameters:
shared_buffers = 1GB
work_mem = 128MB
maintenance_work_mem = 64MB

I have attached the o/p of vmstat command alsp. Can you please help us in
tuning any other parameters.
http://postgresql.1045698.n5.nabble.com/file/n4465765/untitled.bmp






--
View this message in context:
http://postgresql.1045698.n5.nabble.com/100-CPU-Utilization-when-we-run-queries-tp4465765p4465765.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.