Tom Lane wrote: > Richard Huxton <dev@xxxxxxxxxxxx> writes: >> I've never heard of EXPLAIN ANALYSE being *faster* than the actual >> query, it's usually slower due to all the timing calls. The only thing >> it doesn't do is actually send the results over the connection to the >> client. In your case, you're not actually selecting any columns, so that >> can't be it. > > If I'm reading it right the query returns 5000 instances of "1". So > there's definitely scope for the client side to pose a performance > issue. But 34s for 5000 single values? Surely you'd loads of queries slow, not just this "not in" query. -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
