Re: Load sharing question

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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073