Postgres Pro
Downloads
Home   >   mailing lists

[pgsql-cluster-hackers][performance] fast reads on a busy server - Mailing list pgsql-performance

From Willy-Bas Loos
Subject [pgsql-cluster-hackers][performance] fast reads on a busy server
Date
Msg-id CAHnozTgLOqcAZWJu482Nh9K0f2BobXh3LPGYvycvr+Tb8prozw@mail.gmail.com
Whole thread Raw
Responses Re: [pgsql-cluster-hackers][performance] fast reads on a busy server  (Hannu Krosing <hannu@2ndQuadrant.com>)
List pgsql-performance
Tree view
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

pgsql-performance by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Can I do better than this heapscan and sort?
Next
From: Hannu Krosing
Date:
Subject: Re: [pgsql-cluster-hackers][performance] fast reads on a busy server