Re: Benchmarking PG

Manolo _ wrote:
> I'd like to benchmark PG. I'd like to compare sorting performances (time spent, #of disk accesses, # of run produced
etc)of the present Replacement Selection (external sorting) algorithm and of a refinement I'm going to implement. 
>
> I'm new on PG, I just had the idea of how to possibly get better that algorithm and choosed to test it on PG since
it'san open-source DBMS. 
>
> I've been searching the web for a benchmark. I suppose TPC-H and Wisconsin could fit, but had problems when trying to
usethem. 
> Any suggestion on a "good benchmark"?
> Any tutorial on how to use them?

If you want to compare sorting performance in particular, running a big
query that needs a big sort will be much more useful than a generic DBMS
benchmark like TPC-H.

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com