Re: Under the hood of views

От: David Kerr
Тема: Re: Under the hood of views
Дата: ,
Msg-id: 20090813230400.GA5860@mr-paradox.net
(см: обсуждение, исходный текст)
Ответ на: Re: Under the hood of views  (Richard Huxton)
Ответы: Re: Under the hood of views  (Greg Stark)
Список: pgsql-performance

Скрыть дерево обсуждения

Under the hood of views  (David Kerr, )
 Re: Under the hood of views  (Richard Huxton, )
  Re: Under the hood of views  (David Kerr, )
   Re: Under the hood of views  (Greg Stark, )

On Thu, Aug 13, 2009 at 05:28:01PM +0100, Richard Huxton wrote:
- David Kerr wrote:
- >
- >create view test as
- >select a,b,c,d,e,f,g from testtable;
- >
- >select a from test;
- >
- >(does the engine retrieve b-g?)
-
- Shouldn't - the query just gets rewritten macro-style. I don't think it
- eliminates joins if you don't need any columns, but that's not possible
- without a bit of analysis.

Perfect, thanks!

Dave


В списке pgsql-performance по дате сообщения:

От: Robert Haas
Дата:
Сообщение: Re: Why is vacuum_freeze_min_age 100m?
От: Jeremy Carroll
Дата:
Сообщение: Memory reporting on CentOS Linux