From Bugzilla Helper:
User-Agent: Mozilla/5.0 (compatible; Konqueror/3; Linux)
Description of problem:
Since upgrading (via RHN) to postgresql-7.0.3-9.2, postmaster has been consuming lots of CPU--and never backing off its usage after startup. The database on my system is used only for webmail address books and is *very, very* lightly utilised.
This happened as soon as I upgraded to the latest postgresql RPM on the redhat-7.1 channel.
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1. Try upgrading to postgresql-7.0.3-9.2 on an up2date 7.1 system.
Actual Results: postmaster process consumes ~95% of CPU.
Expected Results: postmaster should be dormant.
This happened as soon as I upgraded my postgresql packages via RHN due to recently discovered security holes.
I can't seem to reproduce this bug. I have tried loading the server (medium to
high loads) and the CPU usage never increases beyond 3% or so. This behaviour
is consistent over different trials and different machines. It should be noted
that these systems were almost completely base installations with everything
else up to date. Perhaps the error lies somewhere else and it is just
coincidence? The package is essentially the same thing with just a few security
holes filled in here and there ... not much to affect performance in such a