I'm still relatively new to Postgres. I usually just do SQL programming
but have found my self having to administer the DB now. I have I have
a problem on my website that when there is high amounts of traffic
coming from one computer to my web server. I suspect it is because of a
virus. But what when I notice this, my processor drops to 0.0% idle
with postmaster being my highest CPU user. Under normal circumstances
the processor runs >90% idle or <10% used. I have tried tuning postgres
but it doesn't seem to make a difference, unless I am doing something
wrong. If I would like to find a solution other than rewriting all of
my SQL statements and creating them to take the least amount of time to
process.