Re: Best replication solution? - Mailing list pgsql-performance

From Heikki Linnakangas
Subject Re: Best replication solution?
Date
Msg-id 49D9BCCA.7060609@enterprisedb.com
Whole thread Raw
In response to Re: Best replication solution?  (Lists <lists@on-track.ca>)
Responses Re: Best replication solution?
Re: Best replication solution?
List 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

pgsql-performance by date:

Previous
From: roopasatish
Date:
Subject: probelm with alter table add constraint......
Next
From: Robert Haas
Date:
Subject: Re: difficulties with time based queries