Timeline for How to force Postgres to use an index?
Current License: CC BY-SA 4.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| S Dec 24, 2019 at 12:22 | history | suggested | CommunityBot | CC BY-SA 4.0 |
ST_Point(X, Y) => ST_Point(longitude, latitude) NOT ST_Point(latitude, longitude)
|
| Dec 24, 2019 at 10:20 | review | Suggested edits | |||
| S Dec 24, 2019 at 12:22 | |||||
| Jul 18, 2017 at 13:02 | vote | accept | ipetr | ||
| Jul 18, 2017 at 11:59 | history | edited | pLumo | CC BY-SA 3.0 |
deleted 4 characters in body
|
| Jul 18, 2017 at 11:54 | comment | added | JGH |
Keep both solutions to avoid the shape restriction: filter roughly using the envelope and refine using the st_dwithin function.
|
|
| Jul 18, 2017 at 11:54 | history | edited | pLumo | CC BY-SA 3.0 |
added 705 characters in body
|
| Jul 18, 2017 at 11:49 | history | edited | pLumo | CC BY-SA 3.0 |
added 705 characters in body
|
| Jul 18, 2017 at 11:16 | comment | added | ipetr | Yes, but I don't have a write permission to the db | |
| Jul 18, 2017 at 11:07 | history | answered | pLumo | CC BY-SA 3.0 |