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
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
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