Brian Modra wrote:
> Hi,
> I've been told that PostgreSQL and other similar databases don't work
> well on a parallelised operating system because they make good use of
> shared memory which does not cross the boundary between nodes in a
> cluster.
>
> So I am wondering if any work is being done to make it possible to
> have a single database schema that spans a number of hosts?
>
> For example, a table on one host/node that has a reference to a table
> on another host/node with deletes cascading back.
> e.g.
Not currently. There are some prototypes in development, but those
usually have the same database on all the machines and they share the
load.
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com