[GENERAL] Table Partitioning : Having child tables in multiple database servers

2009-07-07 Thread Ransika de Silva
Hi all, We have got the Table Partitioning of PostgreSQL to work on one database server, where the Parent Table and Inherited Child Tables are on one (1) database server. The question which we need to get answered is, whether we can have the Child Tables in separate database servers? Can you

Re: [GENERAL] Table Partitioning : Having child tables in multiple database servers

2009-07-07 Thread Ransika de Silva
Hello, Many thanks for the quick response. Why I raised the previous question was to get an answer/solution for the following requirement; The client wants to have the freedom of increasing the processor power AND the storage by introducing new database servers. What is your thought on getting

Re: [GENERAL] Table Partitioning : Having child tables in multiple database servers

2009-07-07 Thread Dimitri Fontaine
Hi, Ransika de Silva rans...@gmail.com writes: The client wants to have the freedom of increasing the processor power AND the storage by introducing new database servers. I think the following document will be of interest: http://wiki.postgresql.org/wiki/Image:Moskva_DB_Tools.v3.pdf It