Re: Best replication solution?
Cstdenis <lists@on-track.ca>
From: Lists <lists@on-track.ca>
To: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Cc: ries van Twisk <typo3@rvt.dds.nl>, pgsql-performance@postgresql.org
Date: 2009-04-07T03:44:20Z
Lists: pgsql-performance
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. >