Forum OpenACS Q&A: Postmaster is eating my CPU
As you can see from the ps output, there are several INSERT statements -- these return after restarting Postgres and even rebooting the system. I checked the system log for that server, and there are only ~30 INSERTS over the last ~12 hours (all INSERT into referer_log). Futhermore, I haven't been running any INSERT statements from psql, and no one else has access to this system.
Yesterday, I ran "vacuum analyze" for the first time in a long time -- could that have caused this situation?
This is one for the PG hackers group, I think - Tom Lane's more likely
to be able to give you help here than any of us.
happened to me today. however, it looks like a SELECT is
causing postgres to spin. the only thing i really did to the
database in the past 24 hours is rebuild some views. and, the
site goes live tomorrow. perfect timing!
column. The view that my page was using used that particular
column to determine what rows were a part of the view... Which
ended up causing some serious weirdness. so, just a word of
warning: dont do what i did.