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

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

pgsql-performance by date

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

pgsql-cluster-hackers by date

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

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