Re: subqueries

Поиск
Список
Период
Сортировка
От Tomasz Grobelny
Тема Re: subqueries
Дата
Msg-id 200506201331.43499.tomasz@grobelny.oswiecenia.net
обсуждение исходный текст
Ответ на subqueries  (Tomasz Grobelny <tomasz@grobelny.oswiecenia.net>)
Список pgsql-general
On Monday 20 of June 2005 00:12, you wrote:
> I have such a statement:
> select * from (subquery1) as foo, (subquery2) as bar;
> Both subqueries are reasonably fast (<0.5s) and generate results that have
> several (<10) rows but the whole query takes forever to execute.
Ok, postgresql wanted to be smarter that myself. It expanded the query instead
of executing them in order given by parenthesis. The solution (or just
workaround?) was to set two variables:
from_collapse_limit = 1
join_collapse_limit = 1

Tomek

В списке pgsql-general по дате отправления:

Предыдущее
От: Milan Krcmar
Дата:
Сообщение: External (asynchronous) notifications of database updates
Следующее
От: "Ilja Golshtein"
Дата:
Сообщение: failed to find conversion function from "unknown" to ...