Postgres Pro
Downloads
Home   >   mailing lists

Thread: Table Partitioning : Having child tables in multiple database servers

Table Partitioning : Having child tables in multiple database servers

From
Ransika de Silva
Date:

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?

Thanks & Regards 
--
Ransika De Silva

Re: Table Partitioning : Having child tables in multiple database servers

From
Ransika de Silva
Date:
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

Re: Table Partitioning : Having child tables in multiple database servers

From
Dimitri Fontaine
Date:
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