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. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
