I came upon this article http://www.internetnews.com/dev-news/article.php/3647376 The last 2 paragraphs caught my eyes: "Among the improvements expected in PostgreSQL 8.3 are further performance gains. "'The most exciting of these is an optimization that would improve performance on OLTP systems between 50 percent and 200 percent depending on the application,' Berkus noted. 'However, that feature involves some difficult engineering that may not be ready in time.'" - what kind of optimization was he referring to? - does it really improve OLTP performance across the board by 50 - 200%, or does it only work in special cases? - Will the optimization make it to 8.3? Thanks. ____________________________________________________________________________________ Building a website is a piece of cake. Yahoo! Small Business gives you all the tools to get online. http://smallbusiness.yahoo.com/webhosting ---------------------------(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
