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

--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance

Reply via email to