Re: Scalability (both vertical and horizontal)?

From: Dennis Gearon <gearond(at)fireserve(dot)net>
To: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
Cc: "Duffey, Kevin" <KDuffey(at)marketron(dot)com>, PgSQL General ML <pgsql-general(at)postgresql(dot)org>
Subject: Re: Scalability (both vertical and horizontal)?
Date: 2003-09-18 21:54:25
Message-ID: 3F6A2991.1040408@fireserve.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

OpenVAX, ...... does that mean the source code is open?

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
>
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2003-09-18 22:13:56 Re: PostgreSQL versus MySQL
Previous Message Marc G. Fournier 2003-09-18 21:49:56 Re: need for in-place upgrades (was Re: State of Beta 2)