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
Date: 2012-06-27 13:23:58
Message-ID: CAHnozTjy87V2cxJKBHvVEY_Y3yPp5822vLrmThz6M-Y6sec4qg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-cluster-hackers pgsql-performance

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
>

In response to

Browse pgsql-cluster-hackers by date

  From Date Subject
Next Message Adam Crews 2012-07-19 20:56:48 postgres 9 bind address for replication
Previous Message Ants Aasma 2012-06-27 12:58:22 Re: [PERFORM] [performance] fast reads on a busy server

Browse pgsql-performance by date

  From Date Subject
Next Message Merlin Moncure 2012-06-27 16:49:02 Re: Can I do better than this heapscan and sort?
Previous Message Ants Aasma 2012-06-27 12:58:22 Re: [PERFORM] [performance] fast reads on a busy server