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/ -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
