On Fri, May 25, 2007 at 03:56:35PM -0400, Tom Lane wrote: > 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.
It looks like the estimated cost is lower for 8.2.4 -- could it be that the fact that he's giving it more memory lead to the planner picking a plan that happens to be worse? /* Steinar */ -- Homepage: http://www.sesse.net/ ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq