Postgres Pro
Downloads
Home   >   mailing lists

Re: Desperate: View not using indexes (very slow) - Mailing list pgsql-performance

From Tom Lane
Subject Re: Desperate: View not using indexes (very slow)
Date
Msg-id 25261.1138593058@sss.pgh.pa.us
Whole thread Raw
In response to Desperate: View not using indexes (very slow)  (Jen Sale <js@slipt.net>)
List pgsql-performance
Tree view 
Jen Sale <js@slipt.net> writes:
> can someone please tell me what we did wrong?

Joins against union subqueries aren't handled very well at the moment.
(As it happens, I'm working on that exact problem right now for 8.2,
but that won't help you today.)

The plan indicates that you are using UNION rather than UNION ALL,
which is not helping any.  Do you really need duplicate elimination
in that view?

            regards, tom lane

pgsql-performance by date:

Previous
From: Jen Sale
Date:
Subject: Desperate: View not using indexes (very slow)
Next
From: Charles Sprickman
Date:
Subject: Re: Huge Data sets, simple queries