| From: | "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: 8.2 is 30% better in pgbench than 8.3 |
| Date: | 2007-07-22 15:27:49 |
| Message-ID: | 162867790707220827x7c7b4e9qbcbdbb49e16a633a@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hello,
I checked my tests again I have different results. Now I tested
PostgreSQL on dedicated server. Now 8.3 is about 20% faster. I didn't
see strong impression of autovacuum. All numbers are approximate
only. I did pgbench 3x for folowing configuration: (autovacuum on,
autovacuum off, statistics off) and for -tntransaction (100, 1000,
4000)
-t 100 629/638/639 630/630/646 581/654/656 -- 8.3
443/519/519 542/555/566 670/692/694 -- 8.2
-t 1000 622/626/653 630/635/653 631/631/652 -- 8.3
523/528/541 522/535/550 679/681/690 -- 8.2
-t 4000 632/635/644 248/385/651* 191/401/641* -- 8.3
465/472/520 237/336/538* 249/379/702* -- 8.2
8.2 is faster only if statistics are off
Note:
*I didn't use parametr v (do_vacuum_accounts)
I am sorry for noise
Regards
Pavel Stehule
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2007-07-22 15:53:14 | Re: 8.2 is 30% better in pgbench than 8.3 |
| Previous Message | Greg Smith | 2007-07-22 05:58:25 | Re: 8.2 is 30% better in pgbench than 8.3 |