Re: Glacially slow nested SELECT

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: thatsanicehatyouhave(at)mac(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Glacially slow nested SELECT
Date: 2007-01-15 16:21:47
Message-ID: 16407.1168878107@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

thatsanicehatyouhave(at)mac(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-01-15 16:27:42 Re: Unpredicatable behavior of volatile functions used
Previous Message Aleksander Kmetec 2007-01-15 16:11:00 Re: Unpredicatable behavior of volatile functions used