Re: WIP: Upper planner pathification - Mailing list pgsql-hackers

From Teodor Sigaev
Subject Re: WIP: Upper planner pathification
Date
Msg-id 56D846EB.9040400@sigaev.ru
Whole thread Raw
In response to Re: WIP: Upper planner pathification  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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@sigaev.ru
  WWW: http://www.sigaev.ru/
 



pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Improve error handling in pltcl
Next
From: Petr Jelinek
Date:
Subject: Re: VS 2015 support in src/tools/msvc