[openstreetmap/openstreetmap-website] Serve only trackable and identifiable points and add cursor pagination to the trackpoints API (PR #7322)

[Paul Norman]

pnorman left a comment (openstreetmap/openstreetmap-website#7322)

> ## Execute plans using cursor in gps_points table

I had a look at the plans and [the query plans](https://explain.depesz.com/s/hvlF) looked like they'd perform poorly on planet sized data. This is probably because you're running them on a small dataset. It's also suspect that it's doing an external disk sort on a tiny amount of data.

I ran [one of the explains on prod](https://explain.depesz.com/s/DdUe) but I'm it looks like it needs a suitable gpx_id from prod as well. A backward index scan probably makes little sense in most cases. Could you provide a query to run EXPLAIN ANALYZE on?

-- 
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/openstreetmap-website/pull/7322#issuecomment-5390080518
You are receiving this because you are subscribed to this thread.

Message ID: <openstreetmap/openstreetmap-website/pull/7322/c5390080518 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20260823/16b240a4/attachment.htm>