Achilleas Mantzios <achill@xxxxxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
