Dave Pirotte <[EMAIL PROTECTED]> writes: > We have two servers running pgsql -- an older server running 8.2.3, > and a newer (far superior) one running 8.2.4. One of our reporting > queries is running painfully slowly on 8.2.4, but it executes in a > reasonable timeframe on 8.2.3.
Are you sure you've analyzed all these tables in the 8.2.4 database? Some of the rowcount estimates seem a bit far off. I looked through the CVS logs and didn't find any planner changes between 8.2.3 and 8.2.4 that seem likely to affect your query, so I'm thinking it must be a statistical discrepancy. regards, tom lane ---------------------------(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