@levelsio You use OFFSET? It slows any slightly bigger DB down to a crawl, no matter the index. Postgres, MySQL won't be faster. It always forces a seek to skip results. There are other tactics to make pagination (infinite scrolling) take advantage of indexes https://t.co/LIXjqS4WVR

You use OFFSET? It slows any slightly bigger DB down to a crawl, no matter the index. Postgres, MySQL won't be faster. It always forces a seek to skip results. There are other tactics to make pagination (infinite scrolling) take advantage of indexes