Timeline for Ways to speed up ST_DWithin between millions of segments and thousands of polygons?
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 7, 2019 at 15:04 | comment | added | ziggy | damn - i'd probably need the data to run some tests. you could try st_collect instead of st_union...that may reduce the time | |
| Oct 7, 2019 at 7:19 | comment | added | Pitrako Junior | The query took 40 hours and did not create any tables. I'm puzzled. | |
| Oct 4, 2019 at 18:30 | comment | added | Pitrako Junior | I'm trying the query suggested above by ziggy and it has now been running for more than 24h. | |
| Oct 2, 2019 at 17:45 | history | answered | ziggy | CC BY-SA 4.0 |