Re: [PERFORM] [performance] fast reads on a
busy server
From:
Willy-Bas Loos <willybas(at)gmail(dot)com>
To:
Ants Aasma <ants(at)cybertec(dot)at>
Cc:
pgsql-performance(at)postgresql(dot)org, pgsql-cluster-hackers(at)postgresql(dot)org, Hannu Krosing <hannu(at)2ndquadrant(dot)com>, Greg Smith <greg(at)2ndquadrant(dot)com>
Subject:
Re: [PERFORM] [performance] fast reads on a
busy server
Thank you.
Cheers,
WBL
Op 27 jun. 2012 14:59 schreef "Ants Aasma" <ants(at)cybertec(dot)at> het volgende:
> On Jun 27, 2012 2:29 PM, "Willy-Bas Loos" <willybas(at)gmail(dot)com> wrote:
> > Should i use a larger shared_buffers for the other cluster(s) too, so
> that i bypass the inefficient OS file-cache?
>
> Once the in-memory cluster has filled its shared buffers, the pages go
> cold for the OS cache and get replaced with pages of other clusters that
> are actually referenced.
>
> Ants Aasma
>