Thread: RE: Running several postmaster using same database in p arallel
RE: Running several postmaster using same database in p arallel
From
"Willis, Ian (Ento, Canberra)"
Date:
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@hotmail.com] Sent: Friday, 24 November 2000 7:24 AM To: tgl@sss.pgh.pa.us; Steffen.Schmidt@EMBL-Heidelberg.de Cc: pgsql-general@postgresql.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