Skip site navigation (1) Skip section navigation (2)

Re: caching written values?

From: Thomas Finneid <tfinneid(at)fcon(dot)no>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: caching written values?
Date: 2009-01-22 12:11:23
Message-ID: 4978626B.6050706@fcon.no (view raw or flat)
Thread:
Lists: pgsql-performance
Pavan Deolasee wrote:
> On Thu, Jan 22, 2009 at 4:42 PM, Thomas Finneid <tfinneid(at)fcon(dot)no> wrote:
> 
>> 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?
>>
> 
> Yes. That's how it works.

Is there any possibilites of telling pg to save to disk that memory 
cached data and state when the server is shutdown, so that when the 
server starts up again, itreads it back into the memory?

regards

thomas

In response to

Responses

pgsql-performance by date

Next:From: Thomas FinneidDate: 2009-01-22 12:35:31
Subject: Re: caching written values?
Previous:From: Glyn AstillDate: 2009-01-22 12:06:58
Subject: Re: caching written values?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group