The st_distance "works" but does not take advantage of the gist index, only the KNN <-> does, so it won't scale well...
Anyways, I posted in ruby-pg, so we'll see. On Monday, July 27, 2020 at 9:04:45 AM UTC+3, Aryk Grosz wrote: > > Well...I've simplified the problem some more and took Sequel out of the > question...it could be at the ruby-pg level: > > https://github.com/ged/ruby-pg/issues/346 > > > On Sunday, July 26, 2020 at 10:04:44 PM UTC+3, Jeremy Evans wrote: >> >> On Sunday, July 26, 2020 at 11:55:41 AM UTC-7, Aryk Grosz wrote: >>> >>> Any experts out there have seen this issue before and give me some >>> advice? Is the solution simply to use st_distance whenever I'm doing >>> cursor pagination? >>> >> >> I haven't seen anything like this, but I don't have experience with >> Aurora. If the st_distance approach works, that is what I would use. >> >> Thanks, >> Jeremy >> > -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/sequel-talk/48c15f65-5a08-4763-a35d-c5904a1410f3o%40googlegroups.com.
