the better way to solve this business

[何华荣]

Hi, all

 

My business is:

 

500+ tables(including 50+ big tables: total insert 500000+ records every
second by some c++ base application)

Many order by/join long and complex SQL query(by JDBC) to show the data
report: must finished as soon as possible

 

Now we use the PostgreSQL with partition,  with the data grow, the system
becomes slow.

 

So what is the better way(open source)?

 

Hawq? Greenplum? Pgpool? or any advise?

 

 

Thanks

RiverTime