Hi Rémi,
Thanks a lot for your thorough reply. Especially scenario A.1 has helped
me to improve performance by over an order of magnitude for our most
common use case. My reply got a bit longer, sorry, I wanted to provide a
clearer picture of my setup. For further tests I changed the system,
Hey,
This is an interesting problem for sure.
AS always in the "slow query" topic,
improvement can come from a number of places
- hardware : are your tables on SSD, does your index fit in RAM
- postgres tuning : you have customised postgresql.conf to fit your
hardware
- query writing : your
Hi all,
I am using Postgres 9.6 with PostGIS 2.3 and want to improve the
performance of a bounding box intersection query on a large set of
lines. I asked the same questions two month ago on
gis.stackexchange.com, but didn't get any reply. Therefore, please
excuse me for cross-posting, but I