Achilleas Mantzios <ach...@matrix.gatewaynet.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
-- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
