View columns calculated - Mailing list pgsql-performance

From Peter Darley
Subject View columns calculated
Date
Msg-id PDEOIIFFBIAABMGNJAGPEEGJDEAA.pdarley@kinesis-cem.com
Whole thread Raw
Responses Re: View columns calculated
List pgsql-performance
Folks,
    I have a question about views:  I want to have a fairly wide view (lots of
columns) where most of the columns have some heavyish calculations in them,
but I'm concerned that it will have to calculate every column even when I'm
not selecting them.  So, the question is, if I have 5 columns in a view but
only select 1 column, is the system smart enough to not calculate the unused
columns, or am I taking a performance hit over a smaller view that doesn't
have the extra 4 columns?
Thanks,
Peter Darley


pgsql-performance by date:

Previous
From: Qing Zhao
Date:
Subject: Re: configure shmmax on MAC OS X
Next
From: "Joshua D. Drake"
Date:
Subject: Re: configure shmmax on MAC OS X