From: | Hannu Krosing <hannu(at)2ndQuadrant(dot)com> |
---|---|
To: | Willy-Bas Loos <willybas(at)gmail(dot)com> |
Cc: | pgsql-cluster-hackers(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: [performance] fast reads on a busy server |
Date: | 2012-06-27 07:34:16 |
Message-ID: | 1340782456.12666.45.camel@hvost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-cluster-hackers pgsql-performance |
On Wed, 2012-06-27 at 00:16 +0200, Willy-Bas Loos wrote:
> Hi,
>
> I've read this:
> http://wiki.postgresql.org/wiki/Prioritizing_databases_by_separating_into_multiple_clusters
>
> But it doesn't really say anything about memory.
> If i can fit an extra cluster into it's shared buffer, it should have
> fast reads, right?
> Even if i don't have seperate spindles and the disks are busy.
Check if you are CPU-bound. On a database which fits fully you may
already be.
> This is on a Debain server, postgres 8.4
And if possible, upgrade to latest pg (9.1). On some operations this
already may give you a considerable performance boost
> Cheers,
>
> WBL
> --
> "Quality comes from focus and clarity of purpose" -- Mark Shuttleworth
>
--
-------
Hannu Krosing
PostgreSQL Unlimited Scalability and Performance Consultant
2ndQuadrant Nordic
PG Admin Book: http://www.2ndQuadrant.com/books/
From | Date | Subject | |
---|---|---|---|
Next Message | Willy-Bas Loos | 2012-06-27 10:01:51 | Re: [performance] fast reads on a busy server |
Previous Message | Willy-Bas Loos | 2012-06-26 22:16:55 | [performance] fast reads on a busy server |
From | Date | Subject | |
---|---|---|---|
Next Message | Willy-Bas Loos | 2012-06-27 10:01:51 | Re: [performance] fast reads on a busy server |
Previous Message | Willy-Bas Loos | 2012-06-26 22:16:55 | [performance] fast reads on a busy server |