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  (Bruce Momjian <bruce@momjian.us>)
Список 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 по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: current_user in seucurity DEFINER functions
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: [HACKERS] Retiring from the PostgreSQL core team