Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> wrote:
> The other form (NOT IN) is the problem (in the case of
> postgresql-9.0.2). (in 8.3 both queries are fast)
So running EXPLAIN ANALYZE for this plan on the 9.0 version checks
the time in more places than the 8.3 version. For a plan that's an
order of magnitude slower than the plan used by the recommended
version of the query. Have you looked at what options you have for
getting a faster clock reading on this "slower/older machine"? Is
there something you're asking for as a change to the PostgreSQL
product?
-Kevin