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