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

[performance] fast reads on a busy server

From: Willy-Bas Loos <willybas(at)gmail(dot)com>
To: pgsql-cluster-hackers(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org
Subject: [performance] fast reads on a busy server
Date: 2012-06-26 22:16:55
Message-ID: CAHnozTgLOqcAZWJu482Nh9K0f2BobXh3LPGYvycvr+Tb8prozw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-cluster-hackerspgsql-performance
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.
This is on a Debain server, postgres 8.4

Cheers,

WBL
-- 
"Quality comes from focus and clarity of purpose" -- Mark Shuttleworth

Responses

pgsql-performance by date

Next:From: Hannu KrosingDate: 2012-06-27 07:34:16
Subject: Re: [performance] fast reads on a busy server
Previous:From: Merlin MoncureDate: 2012-06-26 13:42:34
Subject: Re: Can I do better than this heapscan and sort?

pgsql-cluster-hackers by date

Next:From: Hannu KrosingDate: 2012-06-27 07:34:16
Subject: Re: [performance] fast reads on a busy server
Previous:From: Josh BerkusDate: 2012-05-11 18:21:35
Subject: Agenda For 3rd Cluster Hackers Summit, May 15th in Ottawa

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