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.
---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
