[Pkg-nagios-devel] Bug#296100: nagios-pgsql: postgres process eats 6% CPU

[Marcus Better]

Package: nagios-pgsql
Version: 2:1.3-cvs.20050116-1
Severity: normal

When running nagios, CPU usage for the postgres process is permanently
around 5-7%.

The "ps" command shows the following:

 8131 ?        D      3:37 postgres: nagios nagios 127.0.0.1 DELETE

"top" gives the following:

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
 8131 postgres  15   0 18592  11m  10m D  6.0  2.2   2:44.58 postmaster

This is an AMD Athlon XP 2400+ system. I have other postgres processes
running too, but they don't take any noticeable amount of CPU
normally.

The postgres log shows the following from time to time:

-------------------------------------------------------
2005-02-20 11:10:01 [20983] LOG:  connection received: host=127.0.0.1 port=33116
2005-02-20 11:10:01 [20983] LOG:  connection authorized: user=nagios database=nagios
2005-02-20 11:10:03 [20983] WARNING:  skipping "programretention" --- only table or database owner can vacuum it
2005-02-20 11:10:03 [20983] WARNING:  skipping "hostretention" --- only table or database owner can vacuum it
2005-02-20 11:10:03 [20983] WARNING:  skipping "serviceretention" --- only table or database owner can vacuum it
-------------------------------------------------------

The database was created using the scripts in the distribution.

-- System Information:
Debian Release: 3.1
  APT prefers testing
  APT policy: (990, 'testing'), (500, 'unstable')
Architecture: i386 (i686)
Kernel: Linux 2.6.10-thales
Locale: LANG=sv_SE.UTF-8, LC_CTYPE=sv_SE.UTF-8 (charmap=UTF-8)

Versions of packages nagios-pgsql depends on:
ii  libc6               2.3.2.ds1-20         GNU C Library: Shared libraries an
ii  libgd2-noxpm        2.0.33-1.1           GD Graphics Library version 2 (wit
ii  libjpeg62           6b-9                 The Independent JPEG Group's JPEG 
ii  libpng12-0          1.2.8rel-1           PNG library - runtime
ii  libpq3              7.4.7-2              PostgreSQL C client library
ii  nagios-common       2:1.3-cvs.20050116-1 A host/service/network monitoring 
ii  zlib1g              1:1.2.2-3            compression library - runtime

-- no debconf information