caching written values?

From: Thomas Finneid <tfinneid(at)fcon(dot)no>
To: pgsql-performance(at)postgresql(dot)org
Subject: caching written values?
Date: 2009-01-22 11:12:15
Message-ID: 4978548F.9050301@fcon.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Pavan Deolasee 2009-01-22 11:20:21 Re: caching written values?
Previous Message Thomas Markus 2009-01-22 07:06:12 Re: caching indexes and pages?