Re: [Postgres-xc-general] Performance difference between postgress and postgres-XC

[Mason S. <ms...@tr...>]

On Mon, Feb 24, 2014 at 3:26 PM, Nirmal Sharma <sha...@gm...>wrote:

> Also, can you please explain what do you mean by TPC-C and TPC-H?
>

These are different types of benchmarks. See http://www.tpc.org


> We are actually using PG for our reporting application that read the data
> from database by running complex queries (query uses aggregate and wndows
> functions) and we are using connection pools for users to connect and view
> data from application. Also, users can changes the data ( update/insert)
> from the application.
> So do you think that our application is TPC-H?
>

I am guessing that not all queries are slow, just some queries. You may
have to run EXPLAIN to examine what is going on.  This type of query
handling is an area that could be improved in Postgres-XC. If you can get
by without window functions, you could take a look at the Stado project. I
recommend this branch: https://code.launchpad.net/~sgdg/stado/stado



-- 
Mason Sharp

TransLattice - http://www.translattice.com
Distributed and Clustered Database Solutions