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:

Previous
From: Ron Johnson
Date:
Subject: Re: Scalability (both vertical and horizontal)?
Next
From: Andrew Rawnsley
Date:
Subject: Sequences