X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DE9133A5427 for ; Tue, 30 Nov 2004 19:08:03 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 67730-07 for ; Tue, 30 Nov 2004 19:07:36 +0000 (GMT) Received: from office.realtyserver.com (vpn1.realtyserver.com [142.179.100.60]) by svr1.postgresql.org (Postfix) with ESMTP id AE6393A53E4 for ; Tue, 30 Nov 2004 19:06:04 +0000 (GMT) Received: from [192.168.1.184] ([192.168.1.184]) by office.realtyserver.com with Microsoft SMTPSVC(6.0.3790.211); Tue, 30 Nov 2004 11:23:03 -0800 Message-ID: <41ACC41B.3050206@markreid.org> Date: Tue, 30 Nov 2004 11:03:55 -0800 From: m User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.3) Gecko/20040910 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Adile Abbadi Cc: pgsql-admin@postgresql.org Subject: Re: Load Balancing/Multiple Postgres Machines References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 30 Nov 2004 19:23:03.0875 (UTC) FILETIME=[0358C930:01C4D712] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.1 tagged_above=0.0 required=5.0 tests=NO_DNS_FOR_FROM X-Spam-Level: * X-Archive-Number: 200411/201 X-Sequence-Number: 15584 Adile Abbadi wrote: > Hi all, > > Not sure if this has been asked before - it probably has been - but I > figure its probably just easier if I ask so my question is this: > > How easy is it - or rather is it possible to create multiple instances > of the same db on multiple machines? > > We are currently running a very highly used postgres db (Ver 7.2) that > eats up a lot of cpu time when its heavily used. We recently bought > some very powerful equipment to accommodate this high use, (currently > its on a single CPU, 1GB of Ram SCSI server - upgraded to a dual CPU, > 4GB of ram SCSI server) but my fear is over time this issue is going > to haunt me again and hardware can only be upgraded so much. > > So is it possible to do some level of load balancing in postgres - I > would love a situation where I could have multiple machines running > multiple instances of the same db (that are all synced in real-time), > where there is some smart level of load balancing happening. > > So if it is possible is there some instruction info out there to help > me along my way. Any help or insight would be greatly appreciated. > > All the best > > Adile > Hello, I read an interesting paper on this a while ago, you can find it here: http://www.cnds.jhu.edu/pub/papers/cnds-2003-3.pdf It's called "On the Performance of Consistent Wide-Area Database Replication", and presents an analysis of a Postgres-based replication system. Unfortunately, the implementation wasn't made available, but the ideas may be worth investigating for someone with more free time than myself. -Mark.