Re: subselects vs WITH in views
От | Merlin Moncure |
---|---|
Тема | Re: subselects vs WITH in views |
Дата | |
Msg-id | CAHyXU0x+5oLuWTmao2BPQBMUE0u+fr_esm5z_UciFnb_aykOnA@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: subselects vs WITH in views (Joe Van Dyk <joe@tanga.com>) |
Ответы |
Re: subselects vs WITH in views
|
Список | pgsql-general |
On Tue, Feb 19, 2013 at 9:22 AM, Joe Van Dyk <joe@tanga.com> wrote: > On Tue, Feb 19, 2013 at 1:02 AM, Albe Laurenz <laurenz.albe@wien.gv.at> > wrote: >> >> Joe Van Dyk wrote: >> > My assumption was that WITH acted just like subselects, but apparently >> > they don't? Using WITH doesn't >> > use the expected index. >> >> Currently WITH acts as an "optimization fence", that means >> that means that the planner won't move conditions into or >> out of the WITH query. > > > Where's the best place to read up on this? Unfortunately, the mailing list archives. Rightly or wrongly, postgresql docs are exceptionally light in terms of performance aspects of various SQL mechanisms. (non-data modifying) WITH is basically formalization of technique: A extract to temp table B query that table. Not the optimization fence characteristic is an implementation detail and not future proofed but is nevertheless widely replied upon. merlin
В списке pgsql-general по дате отправления: