Hi all, I would like to submit two ideas:
1/ In the daily tasks I have as (also) a standard DBA, I found usefull to view locks in a human point of view. I think the "~ '^pg_'" part of the queries may be not so clean... Any ideas welcome :) 2/ Also, I like having a cache hit/miss ratio. This is why I add a function "pg_stat_get_db_hit_miss_ratio(database oid)" to pg_stat_database, in a "bis" view. Since I dont want to flood the mailing list with a possible useless thing, I put my sql/plpgsql code here: http://priam.dalibo.net/~jpa/propositions/ Please take a look at it and tell me if this could be usefull or not.. Thanks a lot, -- Jean-Paul Argudo www.postgresqlfr.org www.dalibo.com ---------------------------(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