> Say, if you first SELECT fname, lname FROM user_table;
> and then you issue SELECT * FROM user_table; -- the
> second select will be returned from buffer cache -- since
> all rows are already in the cache.
...Unless your table contains some large TEXT columns that have been
stored out of line (TOASTed) by postgres.