Re: postgresql roadmap for horizontal scalability? - Mailing list pgsql-hackers

From Andrew Hammond
Subject Re: postgresql roadmap for horizontal scalability?
Date
Msg-id 1165251412.345120.257320@73g2000cwn.googlegroups.com
Whole thread Raw
In response to Re: postgresql roadmap for horizontal scalability?  ("Timasmith" <timasmith@hotmail.com>)
List pgsql-hackers
Timasmith wrote:
>
> That is awesome.  I am not worried about the time to replicate - this
> is supposed to be static, very infrequently changing data (like form
> controls, security etc.)  so there is no expectation changes are real
> time.

Be very sure that this is covered in the specifications or you may end
up with PHB types asking you why the changes aren't propagated in real
time.

> I am envisioning a powerful,.highly available central server and then a
> slew of cheap servers.

If you intend to use the slony based approach above, then I suggest
that your cheap servers need to be reliable. In the event of a single
node's failure, cruft will begin accumulating on all the nodes until
that node is either dropped or brought back online and catches back up.

Drew



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Notify enhancement
Next
From: Tom Lane
Date:
Subject: Re: [PATCHES] Bundle of patches