From: | Brian Modra <epailty(at)googlemail(dot)com> |
---|---|
To: | PGSQL Mailing List <pgsql-general(at)postgresql(dot)org> |
Subject: | Clustering, parallelised operating system, super-computing |
Date: | 2010-05-13 08:36:20 |
Message-ID: | AANLkTikXDfdeYOQj6BGZjsnLXzAyerWaTvDZfua81gTr@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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/
From | Date | Subject | |
---|---|---|---|
Next Message | Simon Riggs | 2010-05-13 08:45:15 | Re: [HACKERS] Retiring from the PostgreSQL core team |
Previous Message | Pavel Stehule | 2010-05-13 07:21:46 | Re: current_user in seucurity DEFINER functions |