| From: | Heikki Linnakangas <heikki(at)enterprisedb(dot)com> |
|---|---|
| To: | Manolo _ <mac_man2005(at)hotmail(dot)it> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Benchmarking PG |
| Date: | 2007-12-11 12:11:29 |
| Message-ID: | 475E7E71.1070701@enterprisedb.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Manolo _ | 2007-12-11 13:23:31 | Is it spam or not? |
| Previous Message | Manolo _ | 2007-12-11 11:57:24 | Is it spam or not? |