<i>>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.</i><p>the new Bloom index (9.6) can help here ?
<a href="http://www.postgresql.org/docs/devel/static/bloom.html" rel="nofollow">http://www.postgresql.org/docs/devel/static/bloom.html</a><p>--<p>the SQL queries:<p>Q4: <a href="https://github.com/tvondra/pg_tpch/blob/master/dss/templates/4.sql" rel="nofollow">https://github.com/tvondra/pg_tpch/blob/master/dss/templates...</a><p>Q5: <a href="https://github.com/tvondra/pg_tpch/blob/master/dss/templates/5.sql" rel="nofollow">https://github.com/tvondra/pg_tpch/blob/master/dss/templates...</a><p>Q6: <a href="https://github.com/tvondra/pg_tpch/blob/master/dss/templates/6.sql" rel="nofollow">https://github.com/tvondra/pg_tpch/blob/master/dss/templates...</a><p>Q7: <a href="https://github.com/tvondra/pg_tpch/blob/master/dss/templates/7.sql" rel="nofollow">https://github.com/tvondra/pg_tpch/blob/master/dss/templates...</a><p>Q14: <a href="https://github.com/tvondra/pg_tpch/blob/master/dss/templates/14.sql" rel="nofollow">https://github.com/tvondra/pg_tpch/blob/master/dss/templates...</a><p>Q15: <a href="https://github.com/tvondra/pg_tpch/blob/master/dss/templates/15.sql" rel="nofollow">https://github.com/tvondra/pg_tpch/blob/master/dss/templates...</a><p>Q20: <a href="https://github.com/tvondra/pg_tpch/blob/master/dss/templates/20.sql" rel="nofollow">https://github.com/tvondra/pg_tpch/blob/master/dss/templates...</a>