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

From: Ransika de Silva <ransika(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Table Partitioning : Having child tables in multiple database servers
Date: 2009-07-07 15:38:43
Message-ID: a5af5afc0907070838p166b8cd8qfeceaee5529033c8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)gmail(dot)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(at)gmail(dot)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(at)gmail(dot)com>
> >>
> >> On Tue, Jul 7, 2009 at 3:32 PM, Ransika de Silva<ransika(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Fetter 2009-07-07 15:40:06 Re: combine multiple row values in to one row
Previous Message Ransika de Silva 2009-07-07 14:32:38 Table Partitioning : Having child tables in multiple database servers