Re: Best replication solution?

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: Lists <lists(at)on-track(dot)ca>
Cc: ries van Twisk <typo3(at)rvt(dot)dds(dot)nl>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Best replication solution?
Date: 2009-04-06 08:26:50
Message-ID: 49D9BCCA.7060609@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Robert Haas 2009-04-06 10:37:13 Re: difficulties with time based queries
Previous Message roopasatish 2009-04-06 06:54:33 probelm with alter table add constraint......