Kaloyan Iliev Iliev <kaloyan@digsys.bg> 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