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): How reproducible: Always Steps to Reproduce: 1. Try upgrading to postgresql-7.0.3-9.2 on an up2date 7.1 system. 2. 3. Actual Results: postmaster process consumes ~95% of CPU. Expected Results: postmaster should be dormant. Additional info: 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 major way. Marking WORKSFORME.