Michael,
It could be we can find other optimzations as well. Paul, is there a simple way to log all DB queries to a separate file? Like this, we could log for a typical day, and then see which are the most queries and where we could start to optimize. I know you, Paul, have other things to do - so a query log would be nice that we can share here, and let the community optimize it. I'm sure there are some DB gurus on this list :-)
On PostgreSQL, the way you do this is by adding log_statement and log_duration options, which will add queries and their execution times to the activity log. If you can do this on PostgresQL 8.3, you can keep the log in CSV format and then run aggregate queries to determine which queries are tripping you up.
I'll be tackling a lot of this (at least for the PostgreSQL version) once I'm up and running on it.
--Josh _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
