On Jun 26, Chris Wilson modulated: > I created the index starting with date and it did make a big > difference: down to 10.3 seconds using a bitmap index scan and bitmap > heap scan (and then two hash joins as before). > By the way, what kind of machine are you using? CPU, RAM, backing storage? I tried running your original test code and the query completed in about 8 seconds, and adding the index changes and analyze statement brought it down to around 2.3 seconds on my workstation with Postgres 9.5.7. On an unrelated development VM with Postgres 9.6.3, the final form took around 4 seconds. Karl -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
