On Tue, May 15, 2007 at 06:33:26AM +0200, Dawid Kuroczko wrote:
> Well, views are not going to help with memory consumption here.
> It is the table contents that gets cached in buffer cache, not the
> views contents. So if you have a view which returns only one
> column from 15-column table, you will be caching that 15-column
> data nonetheless. View, as the name states, is converted into
> a select on a real table.
Are you saying that in Postgresql:
select first_name, last_name from user_table;
uses the same memory as this?
select first_name, last_name,
passowrd, email,
[10 other columns]
from user_table;
--
Bill Moseley
[EMAIL PROTECTED]
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
