Re: [Postgres-xc-general] Postgresql - Postgres-XC

[Michael P. <mic...@gm...>]

On Sun, Dec 30, 2012 at 2:59 AM, Iwan Sofana <iwa...@ya...> wrote:

> Hi Michael,
>
> Thank you for comprehensive explanation.
>
> About 2 months ago, we start using PostgreSQL on 4 Core
> Xeon. The size of database now increase up to 800 GB and CPU utilization
> is about 40-60%.
>
I heard the limit of a Postgres database is 2TB somewhere so you still got
some time until reaching that but yes the CPU might become a bottleneck if
the use rate has such an average.


> I am not sure the server is strong enough for next two/three months.
> I just thinking to replace it with a new one.
> But by doing this the old server become useable.
> It seems I need write scalability clustering.
>
Does your system use heavily read or write operations?
The tables that are heavily read would need to be replicated to share the
read load between nodes and the tables being written a lot would need to be
distributed.
--
Michael Paquier
http://michael.otacoo.com