| 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
>
| 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 |
| 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 |