Message-ID: <49DACC14.3050601@on-track.ca>
Date: Mon, 06 Apr 2009 20:44:20 -0700
From: Lists <lists@on-track.ca>
User-Agent: Thunderbird 2.0.0.21 (Windows/20090302)
MIME-Version: 1.0
To: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
CC: ries van Twisk <typo3@rvt.dds.nl>, pgsql-performance@postgresql.org
Subject: Re: Best replication solution?
References: <49D8FA31.8010407@on-track.ca>
	<480ED41A-B4AF-4A14-A10B-9F7181D7949D@rvt.dds.nl>
	<49D9293D.2020101@on-track.ca> <49D9BCCA.7060609@enterprisedb.com>
In-Reply-To: <49D9BCCA.7060609@enterprisedb.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

I'm currently running 32bit FreeBSD so I can't really add more ram (PAE 
doesn't work well under FreeBSD from what I've read) and there are 
enough writes that more ram won't solve the problem completely.

However I will add plenty more ram next time I rebuild it.


Heikki Linnakangas wrote:
> 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.
>