PostgreSQL 9.6 with Parallel Query vs. TPC-H

rhaas.blogspot.com

12 pointsioltas2 comments

>Many of these queries - Q4, Q5, Q6, Q7, Q14, Q15, and Q20 -would have been better off using a bitmap index scan on the driving table, but unfortunately that's not supported in PostgreSQL 9.6.

the new Bloom index (9.6) can help here ? http://www.postgresql.org/docs/devel/static/bloom.html

--

the SQL queries:

Q4: https://github.com/tvondra/pg_tpch/blob/master/dss/templates...

Q5: https://github.com/tvondra/pg_tpch/blob/master/dss/templates...

Q6: https://github.com/tvondra/pg_tpch/blob/master/dss/templates...

Q7: https://github.com/tvondra/pg_tpch/blob/master/dss/templates...

Q14: https://github.com/tvondra/pg_tpch/blob/master/dss/templates...

Q15: https://github.com/tvondra/pg_tpch/blob/master/dss/templates...

Q20: https://github.com/tvondra/pg_tpch/blob/master/dss/templates...

Postgres does support bitmap index scans, the issue Robert mentions here is that those currently cannot be the "driving" table in a parallel scan.

Reply on news.ycombinator.com