Re: Database block lifecycle

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Database block lifecycle
Date: 2014-08-12 22:56:18
Message-ID: 53EA9B92.3030108@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 8/12/2014 3:52 PM, pinker wrote:
> Ok, I wasn't precisely enough, you are right. It's brand new server,
> nothing is yet configured and we have not even os installed. The
> number was the overall count we expect for a whole cluster.
>
> But the main question is: is it possible to completely avoid disk read
> if there is huge amount of RAM available?

the OS file cache will ensure that.

--
john r pierce 37N 122W
somewhere on the middle of the left coast

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tatsuo Ishii 2014-08-13 00:33:00 Re: Database block lifecycle
Previous Message pinker 2014-08-12 22:52:05 Re: Database block lifecycle