From: bakkiya <bakkiya@gmail.com>
To: pgsql-performance@postgresql.org
Subject: 100% CPU Utilization when we run queries.
Date: Tue, 7 Jun 2011 21:19:28 -0700 (PDT)
Message-ID: <1307506768241-4465765.post@n5.nabble.com> (raw)
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.ht...
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: bakkiya@gmail.com
Subject: Re: 100% CPU Utilization when we run queries.
In-Reply-To: <1307506768241-4465765.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox