Clustering, parallelised operating system, super-computing

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/

Responses

Browse pgsql-general by date

  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