[PERFORM] Problems with high traffic

2005-01-06 Thread Ben Bostow
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 wh

Re: [PERFORM] Problems with high traffic

2005-01-06 Thread Ben Bostow
true) On your last point, that is where you will get the most optimization, but I'd still use log_duration to make sure optimizing the statement will actually help. dave Ben Bostow wrote: I'm still relatively new to Postgres. I usually just do SQL programming but have found my self havin

Re: [PERFORM] Problems with high traffic

2005-01-06 Thread Ben Bostow
Why do random hits to your web server cause postgres activity? Is your site dynamically created from the database ? Dave Ben Bostow wrote: I am running postgresql 7.2.4-5.73, Dual P4, 1GB Ram. The big problem is that I redirect all internal port 80 traffic to my web server so I see all traffi