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

From Ron Johnson
Subject Re: High-volume shop uses PostgreSQL
Date
Msg-id 1063879475.11739.1579.camel@haggis
Whole thread Raw
In response to Re: High-volume shop uses PostgreSQL  (Gaetano Mendola <mendola@bigfoot.com>)
Responses Re: High-volume shop uses PostgreSQL
List pgsql-general
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.

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

484,246 sq mi are needed for 6 billion people to live, 4 persons
per lot, in lots that are 60'x150'.
That is ~ California, Texas and Missouri.
Alternatively, France, Spain and The United Kingdom.


pgsql-general by date:

Previous
From: Kaare Rasmussen
Date:
Subject: Re: High-volume shop uses PostgreSQL
Next
From: Ron Johnson
Date:
Subject: Re: Why does adding SUM and GROUP BY destroy performance?