caching written values? - Mailing list pgsql-performance

From Thomas Finneid
Subject caching written values?
Date
Msg-id 4978548F.9050301@fcon.no
Whole thread Raw
Responses Re: caching written values?  (Pavan Deolasee <pavan.deolasee@gmail.com>)
Re: caching written values?  (Glyn Astill <glynastill@yahoo.co.uk>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Thomas Markus
Date:
Subject: Re: caching indexes and pages?
Next
From: Pavan Deolasee
Date:
Subject: Re: caching written values?