From: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> |
---|---|
To: | PgSQL General ML <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: High-volume shop uses PostgreSQL |
Date: | 2003-09-18 21:32:55 |
Message-ID: | 1063920774.11720.1610.camel@haggis |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)l(dot)johnson(at)cox(dot)net
Jefferson, LA USA
"Object-oriented programming is an exceptionally bad idea which
could only have originated in California."
Edsger Dijkstra
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Sullivan | 2003-09-18 21:33:11 | Re: need for in-place upgrades (was Re: State of Beta 2) |
Previous Message | scott.marlowe | 2003-09-18 21:32:46 | Re: Scalability (both vertical and horizontal)? |