| From: | Teodor Sigaev <teodor(at)sigaev(dot)ru> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-hackers(at)postgresql(dot)org, Robert Haas <robertmhaas(at)gmail(dot)com> |
| Subject: | Re: WIP: Upper planner pathification |
| Date: | 2016-03-03 14:15:07 |
| Message-ID: | 56D846EB.9040400@sigaev.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> So I see no evidence for a slowdown on pgbench's SELECT queries.
> Anybody else want to check performance on simple scan/join queries?
I did your tests with configure --enable-depend and pgbench -i -s 100 and
slightly tweaked postgresql.conf, on notebook with CPU i7-3520M (2 cores + 2
HT), FreeBSD 10.2.
pgbench -c 4 -j 4 -P 1 -T 60 -S
HEAD 35834 tps avg (35825/35828/35808/35844/35865)
Patched HEAD 35529 tps avg (35516/35561/35527/35534/35510)
~1% slowdown. I can live with that.
--
Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Petr Jelinek | 2016-03-03 14:25:36 | Re: VS 2015 support in src/tools/msvc |
| Previous Message | Pavel Stehule | 2016-03-03 14:12:48 | Re: Improve error handling in pltcl |