Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id ABCC8632886 for ; Mon, 6 Apr 2009 05:27:04 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 58925-03 for ; Mon, 6 Apr 2009 05:26:59 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from exprod7og107.obsmtp.com (exprod7og107.obsmtp.com [64.18.2.167]) by mail.postgresql.org (Postfix) with SMTP id 66E3C632585 for ; Mon, 6 Apr 2009 05:26:59 -0300 (ADT) Received: from source ([209.85.219.174]) by exprod7ob107.postini.com ([64.18.6.12]) with SMTP ID DSNKSdm80DxWwhwqx1zR2oO3if/P9f9XMPgh@postini.com; Mon, 06 Apr 2009 01:26:59 PDT Received: by ewy22 with SMTP id 22so1714956ewy.35 for ; Mon, 06 Apr 2009 01:26:56 -0700 (PDT) Received: by 10.210.141.17 with SMTP id o17mr2728965ebd.29.1239006416134; Mon, 06 Apr 2009 01:26:56 -0700 (PDT) Received: from ?80.223.212.7? (dsl-hkibrasgw2-fed4df00-7.dhcp.inet.fi [80.223.212.7]) by mx.google.com with ESMTPS id 10sm1237254eyz.39.2009.04.06.01.26.55 (version=TLSv1/SSLv3 cipher=RC4-MD5); Mon, 06 Apr 2009 01:26:55 -0700 (PDT) Message-ID: <49D9BCCA.7060609@enterprisedb.com> Date: Mon, 06 Apr 2009 11:26:50 +0300 From: Heikki Linnakangas Organization: EnterpriseDB User-Agent: Mozilla-Thunderbird 2.0.0.19 (X11/20090103) MIME-Version: 1.0 To: Lists CC: ries van Twisk , 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> In-Reply-To: <49D9293D.2020101@on-track.ca> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200904/118 X-Sequence-Number: 33485 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