If my experience with other DBMS (mostly SQL Server) is anything to go by, index only scans will do wonders for append-mostly workloads, and the new transactional scaling looks really good.<p>I can't wait to try this out, alas I use debian so it's a couple of years out :/<p>Also my inner grand prix follower is slightly irked by the varying years of the graphics.
Here's the corresponding video to these slides from a separate event that gives an overview of features in 9.2: <a href="http://vimeo.com/49337386" rel="nofollow">http://vimeo.com/49337386</a>
Although PostgreSQL is featured database enterprises still using mainly SQL Server or Oracle. <a href="http://blog.protegra.com/2012/06/22/sql-server-2012-cheaper-than-open-source-database-options/" rel="nofollow">http://blog.protegra.com/2012/06/22/sql-server-2012-cheaper-...</a> What can we do for wider adoptation of PostgreSQL?
Great talk, love the commentary relating the the index contributions by the Russian contributors really impressive work.<p>Read and write performance improvements are something that will directly improve even current applications.<p>Talks like this provide valuable insight into what is going on in this amazing project.