8.2.1 on FreeBSD 5.4-RELEASE

From: "Paul Khavkine" <paul(dot)khavkine(at)distributel(dot)ca>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: 8.2.1 on FreeBSD 5.4-RELEASE
Date: 2006-02-14 21:36:54
Message-ID: 1139953014.96994.30.camel@paul
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Browse pgsql-performance by date

  From Date Subject
Next Message Jignesh K. Shah 2006-02-14 21:47:20 Re: copy and postgresql.conf
Previous Message Jay Greenfield 2006-02-14 21:25:32 Re: Postgres slower than MS ACCESS