Timeline for Strange performance of a top-N query with Postgres
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 10, 2020 at 19:34 | comment | added | David Lutterkort |
I played a little with indexing, and it turns out that an index on (token, timestamp) reduces the query time to basically nothing (< 5ms)
|
|
| Jan 10, 2020 at 19:10 | comment | added | David Lutterkort | Thanks for your help! I updated the post with more information that shows that that is indeed the reason for the difference in performance | |
| Jan 10, 2020 at 19:10 | vote | accept | David Lutterkort | ||
| Jan 10, 2020 at 8:04 | history | answered | Laurenz Albe | CC BY-SA 4.0 |