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

[sean finney]

--huq684BweRXVnRxX
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Sun, Feb 20, 2005 at 07:14:18PM +0100, Marcus Better wrote:
> Looking at the PgSQL logs, I see statements of the following type=20
> repeating continuously:
> -------------------------------------------
> 2005-02-20 19:06:05 [32291] LOG:  statement: BEGIN TRANSACTION
<snip>

i think this is normal.  i couldn't authoritatively say because i
use mostly nagios-text.

> Then a lot ot INSERT statements follow, apparently one for each service=
=20
> and host. Then I see a COMMIT, and then a new cycle starts within about=
=20
> five seconds.

every five seconds?  that seems a bit much...

> --------------------------------------
> 2005-02-20 19:07:42 [698] LOG:  statement: VACUUM programretention
> 2005-02-20 19:07:42 [698] WARNING:  skipping "programretention" --- only=
=20
> table or database owner can vacuum it
> 2005-02-20 19:07:42 [698] LOG:  statement: VACUUM hostretention
> 2005-02-20 19:07:42 [698] WARNING:  skipping "hostretention" --- only=20
> table or database owner can vacuum it
> 2005-02-20 19:07:42 [698] LOG:  statement: VACUUM serviceretention
> 2005-02-20 19:07:42 [698] WARNING:  skipping "serviceretention" --- only=
=20
> table or database owner can vacuum it
> ---------------------------------------

who's the owner for the database?  have you tried changing it?

> This looks like quite a lot of activity to me, but still doesn't explain=
=20
> the high load. I have around four hosts and 25 services in total.

that is quite a high load for such a small number of hosts.  are you
using any non-standard service checks?

anyway, if changing the db owner doesn't solve the problem, i may
need to have a look at your configs (you can send those off-bts
if you like).


	sean

--=20

--huq684BweRXVnRxX
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFCGN/GynjLPm522B0RAu/eAJ0SzwP7DxXACdNiCCjHxvK77TAEwwCfUXkW
W+oprm+C2HFv7jYKtuupSfE=
=iE1i
-----END PGP SIGNATURE-----

--huq684BweRXVnRxX--