Re: Queries joining views

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Queries joining views
Дата
Msg-id 28484.1156181602@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Queries joining views  ("John D. Burger" <john@mitre.org>)
Ответы Re: Queries joining views
Список pgsql-general
"John D. Burger" <john@mitre.org> writes:
> Anecdotally, I had a situation recently where I got different plans
> depending on whether I queried a join of a view against itself, or
> "macro expanded" the view by hand.  I was =very= surprised at this.

Me too, at least if you didn't do any hand optimization but just stuck
the view definition in as a sub-select.  Can you provide a reproducible
case?

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Queries joining views
Следующее
От: louis gonzales
Дата:
Сообщение: Re: cannot open pg_database