On Mon, Mar 13, 2017 at 8:40 PM, Rafia Sabih <rafia.sa...@enterprisedb.com> wrote: > In an attempt to test v7 of this patch on TPC-H 20 scale factor I found a > few regressions, > Q21: 52 secs on HEAD and 400 secs with this patch
Thanks Rafia. Robert just pointed out off-list that there is a bogus 0 row estimate in here: -> Parallel Hash Semi Join (cost=1006599.34..1719227.30 rows=0 width=24) (actual time=38716.488..100933.250 rows=7315896 loops=5) Will investigate, thanks. > Q8: 8 secs on HEAD to 14 secs with patch Also looking into this one. -- Thomas Munro http://www.enterprisedb.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers