Re: [PERFORM] [performance] fast reads on a busy server

From: Ants Aasma <ants(at)cybertec(dot)at>
To: Willy-Bas Loos <willybas(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org, pgsql-cluster-hackers(at)postgresql(dot)org, Greg Smith <greg(at)2ndquadrant(dot)com>, Hannu Krosing <hannu(at)2ndquadrant(dot)com>
Subject: Re: [PERFORM] [performance] fast reads on a busy server
Date: 2012-06-27 12:58:22
Message-ID: CA+CSw_sryMFRS45ptRq4TYNCREgDKpSS+cyh-f_s-VpiYOLwBA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-cluster-hackers pgsql-performance

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

In response to

Responses

Browse pgsql-cluster-hackers by date

  From Date Subject
Next Message Willy-Bas Loos 2012-06-27 13:23:58 Re: [PERFORM] [performance] fast reads on a busy server
Previous Message Willy-Bas Loos 2012-06-27 11:58:06 Re: [performance] fast reads on a busy server

Browse pgsql-performance by date

  From Date Subject
Next Message Willy-Bas Loos 2012-06-27 13:23:58 Re: [PERFORM] [performance] fast reads on a busy server
Previous Message Willy-Bas Loos 2012-06-27 11:58:06 Re: [performance] fast reads on a busy server