Re: Glacially slow nested SELECT - Mailing list pgsql-general

On 15 Jan 2007, at 16:21, Tom Lane wrote:

> thatsanicehatyouhave@mac.com writes:
>> I have a query that is extraordinarily slow but I don't know why.
>
> It looks like spview is a view with an embedded ORDER BY?  IIRC that
> prevents any meaningful optimization of joins to it --- and
> WHERE-IN-sub-SELECT is a kind of join.

Thanks for the pointer Tom; removing the ORDER BY from the view did
the trick. Is there a reason that the sorting can't be done after the
selection? I suppose I can solve this with a function.

Cheers,

Demitri