Table Partitioning : Having child tables in multiple database servers

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 the above mentioned requirement satisfied.

Thanking you and anticipating a response soon.

@ Grzegorz Jaśkiewicz
Apologies for directly sending you the mail.

Regards
Ransika

2009/7/7 Grzegorz Jaśkiewicz <gryzman@gmail.com>

you should ask the question on the list (press reply-all, not just
reply to my previous message please).

2009/7/7 Ransika de Silva <ransika@gmail.com>:

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 the above mentioned

requirement satisfied.

Thanking you and anticipating a response soon.

Regards,
Ransika

2009/7/7 Grzegorz Jaśkiewicz <gryzman@gmail.com>

On Tue, Jul 7, 2009 at 3:32 PM, Ransika de Silva<ransika@gmail.com>

wrote:

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 please give us your expertise thoughts on this?

no you can't

--
GJ

--
Ransika De Silva
SCMAD 1.0, SCJP 1.4,
BSc.(Hons) Information Systems

--
GJ

--
Ransika De Silva
SCMAD 1.0, SCJP 1.4,
BSc.(Hons) Information Systems

Hi,

Ransika de Silva <ransika@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 presents the architecture Skype is using, and how to achieve what you
need with plproxy and londiste and their other tools.

--
dim