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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
