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 DEC573A4BE2 for ; Tue, 30 Nov 2004 00:07:01 +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 42769-02 for ; Tue, 30 Nov 2004 00:06:57 +0000 (GMT) Received: from mail2.dbitech.ca (radius.wavefire.com [64.141.13.252]) by svr1.postgresql.org (Postfix) with SMTP id 32B8A3A4746 for ; Tue, 30 Nov 2004 00:06:55 +0000 (GMT) Received: (qmail 26792 invoked from network); 30 Nov 2004 01:11:48 -0000 Received: from dbitech.wavefire.com (HELO ?64.141.15.253?) (darcy@64.141.15.253) by radius.wavefire.com with SMTP; 30 Nov 2004 01:11:48 -0000 From: Darcy Buskermolen Organization: Wavefire Technologies Corp. To: pgsql-admin@postgresql.org Subject: Re: Load Balancing/Multiple Postgres Machines Date: Mon, 29 Nov 2004 16:06:50 -0800 User-Agent: KMail/1.6.2 References: <41AB78C8.2070605@commandprompt.com> In-Reply-To: <41AB78C8.2070605@commandprompt.com> MIME-Version: 1.0 Content-Disposition: inline Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Message-Id: <200411291606.50825.darcy@wavefire.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/199 X-Sequence-Number: 15582 On November 29, 2004 11:30 am, Joshua D. Drake wrote: > 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. > > Well you have a very long way to go before you get to that "too much" > stage. > > Within your current platform it should be possible to upgrade to 8GB of > ram and you can almost always add more hard drives. > > > 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. > > You may want to look at pgpool, slony or Mammoth Replicator. > > > 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. You may also want to look at upgrading to PostgreSQL 7.4.6 or 8.0 since they both go a long way to improve performance, which might mittage your CPU bound problem as it is now. > > Sincerely, > > Joshua D. Drake > > > All the best > > > > Adile > > > > --- > > Outgoing mail is certified Virus Free. > > Checked by AVG anti-virus system (http://www.grisoft.com). > > Version: 6.0.801 / Virus Database: 544 - Release Date: 11/24/04 -- Darcy Buskermolen Wavefire Technologies Corp. ph: 250.717.0200 fx: 250.763.1759 http://www.wavefire.com