Mikael Carneholm wrote:
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?
You should probably review the archives on a lot of these topics. Many
of them have been discussed to death :).
In terms of statistics we do have statistics and exhaustive logging that
can provide you with all of that information. Is there something
specific that
the information already provided really doesn't give you?
Materialized views we have, in a sense but much like updateable views
you have to code for it.
"Built In" Failover/Clustering
This won't happen. The community stance, which is a good one is that no
single replication solutions fits everyone's needs and therefore we rely
out the outside
sources. Slony-I, Mammoth Replicator and pgpool being the most popular.
Analytic/window functions:
Get coding man! :) We would love to have them.
Sincerely,
Joshua D. Drake
/Mikael
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: PLphp, PLperl - http://www.commandprompt.com/
