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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
