RE: Running several postmaster using same database in p arallel

From: "Willis, Ian (Ento, Canberra)" <Ian(dot)Willis(at)ento(dot)csiro(dot)au>
To: "'Valter Mazzola'" <txian(at)hotmail(dot)com>, tgl(at)sss(dot)pgh(dot)pa(dot)us, Steffen(dot)Schmidt(at)EMBL-Heidelberg(dot)de
Cc: pgsql-general(at)postgresql(dot)org
Subject: RE: Running several postmaster using same database in p arallel
Date: 2000-11-24 05:05:54
Message-ID: D21A20CD84607E409F314E31F0F68D8A02BEAA@cricket-be.ento.csiro.au.
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

My guess is that the problem is a very difficult one to solve well. The
backends have to reliably communicate between each other in order to stop
two processes writing to the one record. The communication times between 2
processes on the one machine and on two different machines would be at least
1000 time greater. Think of cars going through an intersection with no
traffic lights, just by slowing some cars up and speeding up others gaps can
be made and the problem can be managed. Now think of the same problem with
cars made 1000 time longer, your earlier solution no longer works so well
and the best solution would be to build a different kind of intersection.
The best way would be to make the road a lot wider and to use some sort of
synchronous protocols like traffic lights :-)
Implementations anyone

-----Original Message-----
From: Valter Mazzola [mailto:txian(at)hotmail(dot)com]
Sent: Friday, 24 November 2000 7:24 AM
To: tgl(at)sss(dot)pgh(dot)pa(dot)us; Steffen(dot)Schmidt(at)EMBL-Heidelberg(dot)de
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Running several postmaster using same database in
parallel

many users have asked for this feature (ie load balancing,clustering, of 1
postgresql database)
but no answer from mailing-list, and no planning for this important feature,

i don't understand why.
Why not set-up a site to found this project with donations... on
postgresql.org?

valter mazzola

____________________________________________________________________________
_________
Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com

Browse pgsql-general by date

  From Date Subject
Next Message Igor' Robul' 2000-11-24 05:35:34 Re: plz, Help!! HOW CAN I GET THE ROWNUM IN POSTGRES TABLE AS I DID WITH ORACLE!!
Previous Message bmccoy 2000-11-24 04:02:51 Re: my C pgm