Re: Load sharing question - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Load sharing question
Date
Msg-id 200209100242.g8A2gkX07172@candle.pha.pa.us
Whole thread Raw
In response to Re: Load sharing question  (Andrew Sullivan <andrew@libertyrms.info>)
Responses Re: Load sharing question  (Curt Sampson <cjs@cynic.net>)
List pgsql-general
Andrew Sullivan wrote:
> On Mon, Sep 09, 2002 at 04:22:08PM -0400, Johnson, Shaunn wrote:
> > -- Thanks for the response.
> >
> > -- Right now, all I want to do is some load balancing ( I'm
> > -- sorry ... I should have said this instead of sharing)
> > -- techniques (reviewing MOSIX docs http://www.mosix.cs.huji.ac.il/).
> > -- for PostgreSQL.  I just want to spread the workload
> > -- from one machine to multiple machines and *not* run
> > -- duplicate versions of the database.
>
> Hmm.  PostgreSQL requires that _one_ postmaster be in charge of the
> data area.  I seem to recall someone explaining to me why this made
> MOSIX not work for Postgres, but I can't recall now what the reasons
> were.

We can't make shared memory work across machines.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-general by date:

Previous
From: snpe
Date:
Subject: Re: AutoCommit mode in PostgreSQL (7.3 beta1 from CVS 05.09.2002)
Next
From: Bruce Momjian
Date:
Subject: Re: Real time process monitor in Postgres