Re: High-volume shop uses PostgreSQL - Mailing list pgsql-general

From Ron Johnson
Subject Re: High-volume shop uses PostgreSQL
Date
Msg-id 1063920774.11720.1610.camel@haggis
Whole thread Raw
In response to Re: High-volume shop uses PostgreSQL  (Gaetano Mendola <mendola@bigfoot.com>)
List pgsql-general
On Thu, 2003-09-18 at 10:14, Gaetano Mendola wrote:
> Ron Johnson wrote:
> > On Thu, 2003-09-18 at 03:23, Gaetano Mendola wrote:
> >
> >>Ron Johnson wrote:
> >>
> >>>PostgreSQL does not do horizontal scaling at all, since the postmaster
> >>>can only run on 1 CPU, but it's good at vertical scaling, since it
> >>>can make use of all of the CPUs in a box.  (Well, there's sure to
> >>>be a point at which there is so much activity that the postmaster
> >>>can't handle it all...)
> >>
> >>I seen some PCI cards that permits to have a shared memory shared
> >>between more boxes, I'd like know how much effort is required to permit
> >>postgres to run on two or more machine and have the shared memory shared
> >>between the boxes.
> >
> >
> > HPaq/DEC has a hardware/software product called MemoryChannel, which
> > does that for you.  Of course, it only works with Tru64 and OpenVMS.
>
>
> I knew the existence of this hardware my concern is about made the
> postmaster aware that another postmaster is running on another machine
> and that the underlyng shared memory is shared between two/more boxes.

You'd need mechanisms to synchronize the systems.  Oracle does this
in 9i RAC by licensing Compaq/DEC VAXcluster technology for creating
and managing lock trees across the network.

--
-----------------------------------------------------------------
Ron Johnson, Jr. ron.l.johnson@cox.net
Jefferson, LA USA

"Object-oriented programming is an exceptionally bad idea which
could only have originated in California."
Edsger Dijkstra


pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: need for in-place upgrades (was Re: State of Beta 2)
Next
From: Andrew Sullivan
Date:
Subject: Re: need for in-place upgrades (was Re: State of Beta 2)