Kaloyan Iliev Iliev <kaloyan@xxxxxxxxx> wrote: > The 8.2.15 plan was on an empty database. > On a full database the plan was almost the same. So the question > is could I speed up the plan? Since this is an entirely new query which doesn't include a LEFT JOIN, it's not good to just tack it onto the other thread. Could you please re-post with an appropriate subject and a little more information?: http://wiki.postgresql.org/wiki/SlowQueryQuestions Schema (including indexes), configuration settings, and hardware (CPUs, storage system, and RAM) can be particularly significant. Also, if you could *attach* the EXPLAIN ANALYZE output instead of pasting it within the email, you'd save time for those trying to read it -- emails tend to get word-wrapped in a way which makes them hard to read without manual reformatting. Thanks, -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
