From: Darcy Buskermolen <darcy@wavefire.com>
To: pgsql-admin@postgresql.org
Subject: Re: Load Balancing/Multiple Postgres Machines
Date: Mon, 29 Nov 2004 16:06:50 -0800
Message-ID: <200411291606.50825.darcy@wavefire.com> (raw)
In-Reply-To: <41AB78C8.2070605@commandprompt.com>
References: <NDEDLIMJNEEMMAFHLEEGAEBHCJAA.adile@minitdrugs.com>
<41AB78C8.2070605@commandprompt.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: darcy@wavefire.com
Subject: Re: Load Balancing/Multiple Postgres Machines
In-Reply-To: <200411291606.50825.darcy@wavefire.com>
References: <NDEDLIMJNEEMMAFHLEEGAEBHCJAA.adile@minitdrugs.com> <41AB78C8.2070605@commandprompt.com> <200411291606.50825.darcy@wavefire.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox