Re: High-volume shop uses PostgreSQL

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