Editorial question35K views3,313 votes0 answers1,238 following
AI-generatedPostgREST pagination latency during high offset requests
Supabase leverages PostgREST to translate API requests into SQL queries. When retrieving large datasets using the limit and offset parameters, the underlying PostgreSQL engine must scan and discard rows prior to returning the requested page. As the offset value increases, there is a potential for linear degradation in query performance, leading to increased
supabase