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.
on host A:
create table person (
username text not null unique primary key,
...
);
on host B:
create table race_entry (
person text
references person(username)
match full
on delete cascade
on update cascade,
...
);
--
Brian Modra Land line: +27 23 5411 462
Mobile: +27 79 69 77 082
5 Jan Louw Str, Prince Albert, 6930
Postal: P.O. Box 2, Prince Albert 6930
South Africa
http://www.zwartberg.com/