Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TFs4h-0007WF-RF for pgsql-performance@postgresql.org; Sun, 23 Sep 2012 19:42:43 +0000 Received: from sam.nabble.com ([216.139.236.26]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TFs4g-0000gB-C8 for pgsql-performance@postgresql.org; Sun, 23 Sep 2012 19:42:43 +0000 Received: from [192.168.236.26] (helo=sam.nabble.com) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1TFs4d-0002dy-KO for pgsql-performance@postgresql.org; Sun, 23 Sep 2012 12:42:39 -0700 Date: Sun, 23 Sep 2012 12:42:39 -0700 (PDT) From: "mal.oracledba" To: pgsql-performance@postgresql.org Message-ID: <1348429359621-5725062.post@n5.nabble.com> In-Reply-To: References: <1348058099977-5724566.post@n5.nabble.com> Subject: Re: Newbie performance problem - semop taking most of time ? MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: 0.9 (/) X-Archive-Number: 201209/100 X-Sequence-Number: 47846 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-tp5724566p5725062.html Sent from the PostgreSQL - performance mailing list archive at Nabble.com.