pg.ddx.io pgsql-performance@postgresql.org mailing list archive help / color / mirror / Atom feed From: mal.oracledba <mal.oracledba@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: Newbie performance problem - semop taking most of time ?
Date: Sun, 23 Sep 2012 12:42:39 -0700 (PDT)
Message-ID: <1348429359621-5725062.post@n5.nabble.com> (raw )
In-Reply-To: <CAAZKuFZSf00V6O7JSmn5=okss7TY9i-nhV0v08amdd3naLH7fQ@mail.gmail.com >
References: <1348058099977-5724566.post@n5.nabble.com >
<CAAZKuFZSf00V6O7JSmn5=okss7TY9i-nhV0v08amdd3naLH7fQ@mail.gmail.com >
CPU on the server shows approx 60% used/40 % idle
vmstat 5 5
procs -----------memory---------- ---swap-- -----io---- --system--
-----cpu-----
r b swpd free buff cache si so bi bo in cs us sy id
wa st
18 0 0 160465072 455200 352185248 0 0 37 421 2 0 4
1 95 0 0
14 1 0 160321088 455200 352315040 0 0 0 30559 30496 48583 48
4 46 1 0
1 0 0 160153584 455204 352466624 0 0 13 57266 35147 56949 56
5 38 2 0
19 1 0 160030544 455204 352577504 0 0 13 27765 27924 41981 41
3 54 1 0
10 0 0 159862800 455204 352731776 0 0 29 37807 35591 58193 57
5 37 2 0
A snapshot of 'perf' output for one of the users below. It doesnt change
much from that profile.
PerfTop: 319 irqs/sec kernel: 7.5% exact: 0.0% [1000Hz cycles],
(target_pid: 18450)
---------------------------------------------------------------------------------------------------------------------------------------------
samples pcnt function DSO
_______ _____ ___________________________
________________________________________________
235.00 7.5% AllocSetAlloc
/post/PostgreSQL2/postgresql-9.2rc1/bin/postgres
155.00 5.0% SearchCatCache
/post/PostgreSQL2/postgresql-9.2rc1/bin/postgres
134.00 4.3% hash_search_with_hash_value
/post/PostgreSQL2/postgresql-9.2rc1/bin/postgres
128.00 4.1% LWLockAcquire
/post/PostgreSQL2/postgresql-9.2rc1/bin/postgres
110.00 3.5% _bt_compare
/post/PostgreSQL2/postgresql-9.2rc1/bin/postgres
106.00 3.4% __memcpy_ssse3_back /lib64/libc-2.12.so
106.00 3.4% XLogInsert
/post/PostgreSQL2/postgresql-9.2rc1/bin/postgres
92.00 2.9% cmp_numerics
/post/PostgreSQL2/postgresql-9.2rc1/bin/postgres
73.00 2.3% ExecInitExpr
/post/PostgreSQL2/postgresql-9.2rc1/bin/postgres
64.00 2.0% MemoryContextAlloc
/post/PostgreSQL2/postgresql-9.2rc1/bin/postgres
61.00 1.9% GetSnapshotData
/post/PostgreSQL2/postgresql-9.2rc1/bin/postgres
60.00 1.9% _int_malloc /lib64/libc-2.12.so
58.00 1.9% nocache_index_getattr
/post/PostgreSQL2/postgresql-9.2rc1/bin/postgres
49.00 1.6% PinBuffer
/post/PostgreSQL2/postgresql-9.2rc1/bin/postgres
49.00 1.6% cmp_abs_common
/post/PostgreSQL2/postgresql-9.2rc1/bin/postgres
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Newbie-performance-problem-semop-taking-most-of-time-tp57245...
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
view thread (4+ messages) latest in thread
Message-ID: <1348429359621-5725062.post@n5.nabble.com>
Permalink: ../1348429359621-5725062.post@n5.nabble.com/
Also on: postgresql.org/message-id/1348429359621-5725062.post@n5.nabble.com
copy link · copy postgr.es
reply 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: mal.oracledba@gmail.com
Subject: Re: Newbie performance problem - semop taking most of time ?
In-Reply-To: <1348429359621-5725062.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