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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
