On 5/23/06, Dan Gorman <[EMAIL PROTECTED]> wrote:
In any other DB (oracle, mysql) I know how many queries (selects) per second
the database is executing. How do I get this
number out of postgres?
Mysql does AFAIR only count the number of queries and then uses the
"seconds since startup" to estimate the number of queries per second.
If your server is hammered with queries 1 hour a day it's not giving
you a fair result.
--
regards,
Robin
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
