On Thu, May 15, 2014 at 9:35 AM, Scott Marlowe <scott.marl...@gmail.com>wrote:
> OK so we have a query that does OK in 8.4, goes to absolute crap in > 9.2 and then works great in 9.3. Thing is we've spent several months > regression testing 9.2 and no time testing 9.3, so we can't just "go > to 9.3" in an afternoon. But we might have to. 9.2 seems hopelessly > broken here. > > The query looks something like this: > > SELECT COUNT(*) FROM u, ug > WHERE u.ugid = ug.id > AND NOT u.d > AND ug.somefield IN (SELECT somefunction(12345)); > > In 8.4 we get this plan http://explain.depesz.com/s/r3hF which takes ~5ms > In 9.2 we get this plan http://explain.depesz.com/s/vM7 which takes ~10s > In 9.3 we get this plan http://explain.depesz.com/s/Wub which takes > ~0.35ms > Based on the actual row counts given in the seq scan on u, , in 9.2, u contains millions of rows. In 9.3, it contains zero rows. > > The data sets are identical, the schemas are identical. Please double check that. Cheers, Jeff