Timeline for Can't get this PostgreSQL query to run faster
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 24, 2018 at 17:05 | history | edited | Evan Carroll | CC BY-SA 3.0 |
deleted 7 characters in body
|
| Jan 24, 2018 at 15:48 | vote | accept | Mattis | ||
| Jan 24, 2018 at 15:48 | comment | added | Mattis | Hey! Thanks for replying. I finally found time to loop back around to this. I think you mean to use ST_DWithin in your second code block there. This small change made the query four times faster. Thanks! | |
| Jan 20, 2018 at 21:14 | history | edited | Evan Carroll | CC BY-SA 3.0 |
added 71 characters in body
|
| Jan 20, 2018 at 20:59 | comment | added | Evan Carroll | yes it'll use an index. | |
| Jan 20, 2018 at 20:40 | history | answered | jjanes | CC BY-SA 3.0 |