Timeline for Optimizing an intersection between a single massive multipolygon (WKT) and many features from PostGIS
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Sep 26, 2021 at 7:23 | comment | added | swiss_knight | it was an error due to copy/pasting an old test I did... Previous comment fixed to align to what's in the thread. | |
| Sep 26, 2021 at 6:38 | comment | added | swiss_knight |
Thanks, Will try that! But a small detail that I can see right now is that we also need to call data in the latest FROM clause, so: FROM landcoverpolygons must be FROM landcoverpolygons, data otherwise the ERROR: missing FROM-clause entry for table "data" will be raised.
|
|
| Sep 25, 2021 at 23:40 | comment | added | ziggy | @swiss_knight you don't have tmpdata in your example? | |
| Sep 25, 2021 at 12:26 | history | answered | ziggy | CC BY-SA 4.0 |