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

[Iwan S. <iwa...@ya...>]

At peek hour is about 1000 transaction per second, and the aggregates run over 1250000 rows, possibly will increase again. 

Send by Ojolinux

-----Original Message-----
From: Jim Mlodgenski <ji...@gm...>
Date: Sun, 30 Dec 2012 10:39:55 
To: Iwan Sofana<iwa...@ya...>
Cc: <pos...@li...>
Subject: Re: [Postgres-xc-general] Postgresql - Postgres-XC

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

> I am glade to hear that.
>
>
> > The limit to a single table in PostgreSQL is 32TB so 800GB is still only
> a moderately sized database.
>
> Hundred users from different area can access application and insert data.
> The application doing math calculation (average, sum, min, max) and store
> the result in several tables.
>

About how many transactions per second are you seeing? 100, 1000, 10000?
The aggregates (average, sum) are run over how many rows? 1000, 1 million,
100 million?


>
> > What is the application doing to produce such a high CPU load? Is it
> many concurrent users? A lot of large sorts? etc?
>
> > Understanding why the CPU is high will help determine if XC is the right
> solution to solve your problem. It could be that some simple tuning or
> database maintenance could reduce the CPU load and delay your need to move
> beyond a single server.
>