[–] 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--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... [–] 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.
[–] 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.
2 comments
[ 465 ms ] story [ 133 ms ] threadthe 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...