Timeline for Can't get this PostgreSQL query to run faster
Current License: CC BY-SA 3.0
2 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 24, 2018 at 16:33 | comment | added | Mattis | Hey thanks Evan! Using geography instead of geometry (duh, should have been obvious) cut the query time down even more (~150-200 ms to ~100-120ms). I will look at your other points as soon as I can. Thanks for answering! | |
| Jan 20, 2018 at 21:15 | history | answered | Evan Carroll | CC BY-SA 3.0 |