X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 091CB9DC859 for ; Tue, 14 Feb 2006 17:33:21 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 70354-09 for ; Tue, 14 Feb 2006 17:33:22 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id F41499DC804 for ; Tue, 14 Feb 2006 17:33:18 -0400 (AST) Received: from ottexbe01.corp.distributel.ca (ottexbe01.corp.distributel.ca [206.80.252.36]) by svr4.postgresql.org (Postfix) with ESMTP id 19DDB5AF082 for ; Tue, 14 Feb 2006 21:33:21 +0000 (GMT) Received: from 10.14.61.42 ([10.14.61.42]) by ottexbe01.corp.distributel.ca ([192.168.16.70]) via Exchange Front-End Server 10.14.61.70 ([10.14.61.70]) with Microsoft Exchange Server HTTP-DAV ; Tue, 14 Feb 2006 21:33:18 +0000 Received: from paul.mtl.distributel.net by 10.14.61.70; 14 Feb 2006 16:36:54 -0500 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-raE4ZBrCD2Rk1P3VcQ+t" MIME-Version: 1.0 Content-class: urn:content-classes:message X-MimeOLE: Produced By Microsoft Exchange V6.5 Subject: 8.2.1 on FreeBSD 5.4-RELEASE Date: Tue, 14 Feb 2006 16:36:54 -0500 Message-ID: <1139953014.96994.30.camel@paul> X-MS-Has-Attach: yes X-MS-TNEF-Correlator: Thread-Topic: 8.2.1 on FreeBSD 5.4-RELEASE Thread-Index: AcYxrkVM3y3D9S7CQwanbg8ptqRQmg== From: "Paul Khavkine" To: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.001 required=5 tests=[UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.001 X-Spam-Level: X-Archive-Number: 200602/179 X-Sequence-Number: 17165 --=-raE4ZBrCD2Rk1P3VcQ+t Content-Type: text/plain Content-Transfer-Encoding: quoted-printable Hi Guys. We are running v8.1.2 on FreeBSD 5.4-RELEASE and the server is running with above averege load. When i do top i see alot of postmaster processes in "sbwait" state: # uptime 4:29PM up 23 days, 20:01, 3 users, load averages: 3.73, 1.97, 1.71 # top 82808 pgsql 1 4 0 15580K 12008K sbwait 0 107:06 7.52% postgres 82804 pgsql 1 4 0 15612K 12028K sbwait 0 106:13 7.08% postgres 82806 pgsql 1 4 0 15576K 12008K sbwait 0 106:07 6.84% postgres 82793 pgsql 1 4 0 15576K 12008K sbwait 0 106:05 6.54% postgres 82801 pgsql 1 4 0 15612K 12032K sbwait 0 106:13 5.57% postgres 82800 pgsql 1 4 0 15580K 12012K sbwait 0 105:45 4.88% postgres 6613 pgsql 1 4 0 15612K 12020K sbwait 0 28:47 4.59% postgres 82798 pgsql 1 4 0 15612K 12036K sbwait 0 106:10 4.49% postgres 82799 pgsql 1 4 0 15612K 12036K sbwait 0 106:27 4.39% postgres 82797 pgsql 1 4 0 15612K 12036K sbwait 1 106:23 4.25% postgres 82748 pgsql 1 4 0 15564K 11864K sbwait 0 48:12 3.08% postgres 82747 pgsql 1 4 0 15560K 11848K sbwait 0 47:58 3.08% postgres 82749 pgsql 1 4 0 15564K 11868K sbwait 0 48:27 1.95% postgres 82751 pgsql 1 4 0 15564K 11864K sbwait 0 48:14 1.66% postgres 82739 pgsql 1 4 0 15564K 11868K sbwait 1 48:38 1.37% postgres 82750 pgsql 1 4 0 15564K 11864K sbwait 0 48:07 1.27% postgres The server is not very busy, but it has more or less as many writes as reads. I have not seen more then 10-15 simultaneous queries. Any idea why idle postmaster consume 3-5% CPU ? This is a FreeBSD 5.4-RELEASE server with 2x3G Xeon CPUs, 2G memory, RAID1 mirrored U320 drives. Thanx Paul --=-raE4ZBrCD2Rk1P3VcQ+t Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.2 (FreeBSD) iQCVAwUAQ/JNdvkjFY05CfyYAQJJPwP8C0Rc+pTMqgZ5rQOFoYRfM8daXPqpldjD +yjgdDHD8d+4bwGWKCpNSPzq9hqW7bZPH3yAVxuww34VpEhKUIfj8kyMBnwGlaFn MReMpkyLsgp/fiXcROmnmBrE2VzMv2G4gApWsrTpxNiuba6XFAd5uNHMC6846o9W s/k1LJolhHA= =Q2X9 -----END PGP SIGNATURE----- --=-raE4ZBrCD2Rk1P3VcQ+t--