Hi, I wonder what features other users would like to see in the next version? (8.2) The features I'd (very much) would like to see implemented are: - "Top offender statistics" In other DBMS:es there are functions that allow you to turn on a sort of monitoring that can tell you, for a period of time: 1) which queries that generated the highest I/O 2) which queries that took the longest time to execute 3) percentage of total time spent on I/O wait, CPU time, etc Statistics like these can be very helpful when it comes to identifying application bottlenecks / areas for improvements. - Materialized views What's the status on the matview project? - "Built in" failover/clustering There are lots of projects supplying replication/failover/clustering functionality (Slony-I, pgcluster, pgpool etc), but these are "non-official" in that they do not provide out-of-the box functionality (ie not bundled with a default Pg install) - Analytic/window functions In DBMS:es such as Oracle, there's rank(), dense_rank(), lag(), lead() etc. These functions may(?) be possible to implement using existing/new aggregates. Comments? /Mikael
