Re: Load sharing question - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: Load sharing question
Date
Msg-id 20020909165009.E15959@mail.libertyrms.com
Whole thread Raw
In response to Re: Load sharing question  ("Johnson, Shaunn" <SJohnson6@bcbsm.com>)
Responses Re: Load sharing question  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
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.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_restore not able to restore files larger that 2.4GB
Next
From: "Mihai Gheorghiu"
Date:
Subject: Re: Surprise :-(