Re: Postgres-R: primary key patches - Mailing list pgsql-hackers

From Markus Wanner
Subject Re: Postgres-R: primary key patches
Date
Msg-id 48820E4B.9050603@bluegap.ch
Whole thread Raw
In response to Re: Postgres-R: primary key patches  (chris <cbbrowne@ca.afilias.info>)
List pgsql-hackers
Hi,

chris wrote:
> You may want to have a chat with Jan; he's got some thoughts on a more
> general purpose mechanism that would be good for this as well as for
> (we think) extremely efficient bulk data loading.

Jan, mind to share your thoughts? What use cases for such a general 
purpose mechanism do you see?

What I can imagine doing on top of Postgres-R is: splitting up the data 
and feeding multiple backends with it. Unlike Postgres-R's internal use, 
you'd still have to check the data against constraints, I think.

It would involve the origin backend asking for help from the manager. 
That one checks for available helper backends and then serves as a 
message dispatcher between the origin and helper backends (as it does 
for replication purposes). Please note that it already uses shared 
memory extensively, so the manager doesn't need to copy around the data 
itself.

Regards

Markus


pgsql-hackers by date:

Previous
From: Markus Wanner
Date:
Subject: Re: Postgres-R: primary key patches
Next
From: Tom Lane
Date:
Subject: Re: Getting to universal binaries for Darwin