Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Glacially slow nested SELECT
Date
Msg-id 16407.1168878107@sss.pgh.pa.us
Whole thread Raw
In response to Glacially slow nested SELECT  (thatsanicehatyouhave@mac.com)
Responses Re: Glacially slow nested SELECT  (Demitri Muna <thatsanicehatyouhave@mac.com>)
List pgsql-general
Tree view 
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.

            regards, tom lane

pgsql-general by date:

Previous
From: Aleksander Kmetec
Date:
Subject: Re: Unpredicatable behavior of volatile functions used
Next
From: Tom Lane
Date:
Subject: Re: Unpredicatable behavior of volatile functions used