Hi
A quick question, when pg receives data to be written to a table, does
it cache that data in memory in case a subsequent request/query would
need it?
As I understand it, data is stored in pages and those pages have to be
retrieved in order to write or read data from them. So my assumption is
that a page used to write data would not be replaced until memory is low
and different pages needs to be retrieved. Is this approximately correct?
Thomas