Clustering, parallelised operating system, super-computing
| От | Brian Modra |
|---|---|
| Тема | Clustering, parallelised operating system, super-computing |
| Дата | |
| Msg-id | AANLkTikXDfdeYOQj6BGZjsnLXzAyerWaTvDZfua81gTr@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Clustering, parallelised operating system,
super-computing
|
| Список | 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/
В списке pgsql-general по дате отправления: