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

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 (view raw or flat)
Thread:
Lists: pgsql-cluster-hackerspgsql-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

pgsql-performance by date

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

pgsql-cluster-hackers by date

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

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