[GENERAL] Possible bug (or I don't understand how foreign keys should work with partitions)

2007-06-22 Thread Daniel van Ham Colchete
People, either I don't understand how partitions works or I think I found a bug here. I'm using PostgreSQL-8.2.4 with Gentoo. The code explains: # First I create the table regs with 2 partitions: create table regs (rID serial primary key, name text, number int); create table regs_00 ( CHECK (

Re: [GENERAL] [PERFORM] Postgres Clustering

2009-05-27 Thread Daniel van Ham Colchete
Alan, here I'm implementing something similar to the Chord protocol [1] on the application level to partition my data across 6 PostgreSQL servers with N+1 replication. Two up sides on this approch: 1 - When one server is down the load is spread between all the other ones, instead of going only to