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's an 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 use them.
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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly