4 ms·

PostgreSQL 9.6 with Parallel Query vs. TPC-H

• pella 10y ago
  >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 http://www.postgresql.org/docs/devel/static/bloom.html -- the SQL queries: Q4: https://github.com/tvondra/pg_tpch/blob/master/dss/templates/4.sql https://github.com/tvondra/pg_tpch/blob/master/dss/templates... Q5: https://github.com/tvondra/pg_tpch/blob/master/dss/templates/5.sql https://github.com/tvondra/pg_tpch/blob/master/dss/templates... Q6: https://github.com/tvondra/pg_tpch/blob/master/dss/templates/6.sql https://github.com/tvondra/pg_tpch/blob/master/dss/templates... Q7: https://github.com/tvondra/pg_tpch/blob/master/dss/templates/7.sql https://github.com/tvondra/pg_tpch/blob/master/dss/templates... Q14: https://github.com/tvondra/pg_tpch/blob/master/dss/templates/14.sql https://github.com/tvondra/pg_tpch/blob/master/dss/templates... Q15: https://github.com/tvondra/pg_tpch/blob/master/dss/templates/15.sql https://github.com/tvondra/pg_tpch/blob/master/dss/templates... Q20: https://github.com/tvondra/pg_tpch/blob/master/dss/templates/20.sql https://github.com/tvondra/pg_tpch/blob/master/dss/templates...
  • anarazel 10y ago
    Postgres does support bitmap index scans, the issue Robert mentions here is that those currently cannot be the "driving" table in a parallel scan.