Hi Alex, Actually, our product can partition data among several clustered nodes running PostgreSQL, if that is what you are looking for. Data is distributed based on a designated column. Other tables can be replicated to all nodes.
For SELECTs, it also knows when it can join locally or it needs to ship rows as part of the query plan. For FK constraints (discussed here), it also knows when it can enforce them locally or not. Please let me know if you would like some more information. Regards, Tom Drayton ExtenDB http://www.extendb.com > This is why I mention partitioning. It solves this issue by storing > different data sets on different machines under the same schema. > These seperate chunks of the table can then be replicated as > well for > data redundancy and so on. MySQL are working on these things, but PG > just has a bunch of third party extensions, I wonder why these are > not being integrated into the main trunk :/ Thanks for > pointing me to > PGCluster though. It looks like it should be better than > Slony at least. > ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly