Horton

Re: Best replication solution?

Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>

View thread View on postgr.es
From: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
To: Lists <lists@on-track.ca>
Cc: ries van Twisk <typo3@rvt.dds.nl>, pgsql-performance@postgresql.org
Date: 2009-04-06T08:26:50Z
Lists: pgsql-performance 
Lists wrote:
> Server is a dual core xeon 3GB ram and 2 mirrors of 15k SAS drives (1 
> for most data, 1 for wal and a few tables and indexes)
> 
> In total all databases on the server are about 10G on disk (about 2GB in 
> pgdump format).

I'd suggest buying as much RAM as you can fit into the server. RAM is 
cheap, and with a database of that size more cache could have a dramatic 
effect.

-- 
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com