Karl Denninger <karl@xxxxxxxxxxxxx> wrote: > Kevin Grittner wrote: >> Have you seen such a difference under 8.4? Can you provide a >> self-contained example? > Yes: > > [query and EXPLAIN ANALYZE of fast query] > The alternative: > > [query with no other information] > > goes nuts. Which means what? Could you post an EXPLAIN ANALYZE, or at least an EXPLAIN, of the slow version? Can you post the table structure, including indexes? -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance