Re: Scalability (both vertical and horizontal)? - Mailing list pgsql-general
From | Ron Johnson |
---|---|
Subject | Re: Scalability (both vertical and horizontal)? |
Date | |
Msg-id | 1063936208.11720.1640.camel@haggis Whole thread Raw |
In response to | Re: Scalability (both vertical and horizontal)? (Dennis Gearon <gearond@fireserve.net>) |
List | pgsql-general |
On Thu, 2003-09-18 at 16:54, Dennis Gearon wrote: > Boy, after doing some reading on the net, VAX was WAY ahead of it's > time, like someone else has said. No wonder they did so well back then. > > It'd be nice to get that kind of stuff going on newer products using > fibre channel or that other new, fiber interface. VMSclusters (the name was changed 10 years ago) can interconnect via fiber. > OpenVAX, ...... does that mean the source code is open? The Open in OpenVMS means that it has all the standard Posix & X Window API calls. There's no such thing as OpenVAX, since VAX is a hardware archi- tecture. BTW, VMS has already booted on Itanium, and when it ships early next year, you'll be able to have tri-arch VMSclusters: VAX/VMS, Alpha/VMS & Itaniac/VMS all accessing & sharing the same files simultaneously. > scott.marlowe wrote: > > >On Thu, 18 Sep 2003, Dennis Gearon wrote: > > > > > > > >>scott.marlowe wrote: > >> > >> > >> > >>>On Thu, 18 Sep 2003, Duffey, Kevin wrote: > >>> > >>> > >>> > >>> > >>> > >>>>We are looking for information regarding any capabilities of PostgreSQL > >>>>in regards to scalability. Ideally we want to be able to scale in both > >>>>directions. What sort of solutions are out there for either or both > >>>>directions of scalability? Specifically, open-source solutions would be > >>>>most in need, but commercial applications are fine as well. > >>>> > >>>> > >>>> > >>>> > >>>As for horizontal scaling, you could look at ERserver for that. Setup one > >>>master writer and a bunch of slave boxes to handle the majority of the > >>>queries. There's not been a bunch of work into horizontal scaling really, > >>>with most of the clustering software for postgresql aiming at failover / > >>>high availability, not massive parallelization of read and / or writes. > >>> > >>> > >>> > >>Are there any databases that do well in horizontal scaling? What really > >>*IS* Oracle Real Application Clusters? > >> > >> > > > >I've heard Vax Clusters running RDB do well. > > > >TPF on a mainframe is highly recommended by Sabre, the Airline reservation > >folks. > > > >I've heard horror stories about RAC though. > > > >I don't think there's anysuch thing as an easily configurable high > >performance clustering solution. The better the run the more > >infrastructure (hardware, software, support) they seem to need. > > > > > >---------------------------(end of broadcast)--------------------------- > >TIP 8: explain analyze is your friend > > > > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org) -- ----------------------------------------------------------------- Ron Johnson, Jr. ron.l.johnson@cox.net Jefferson, LA USA Some former UNSCOM officials are alarmed, however. Terry Taylor, a British senior UNSCOM inspector from 1993 to 1997, says the figure of 95 percent disarmament is "complete nonsense because inspectors never learned what 100 percent was. UNSCOM found a great deal and destroyed a great deal, but we knew [Iraq's] work was continuing while we were there, and I'm sure it continues," says Mr. Taylor, now head of the Washington http://www.csmonitor.com/2002/0829/p01s03-wosc.html
pgsql-general by date: