---
title: "Discussion on \"How do you write efficient pagination for millions of rows?\" | Hashnode"
description: "Discussion on \"How do you write efficient pagination for millions of rows?\". Learn efficient pagination for PostgreSQL to optimize API, UI, and high-concurrency performance"
url: "https://hashnode.com/posts/how-to-write-efficient-pagination-for-millions-of-rows/6960701f3d45d04a0f707769"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [How do you write efficient pagination for millions of rows?](https://kiransabne.dev/how-to-write-efficient-pagination-for-millions-of-rows?utm_source=hashnode&utm_medium=feed)

Learn efficient pagination for PostgreSQL to optimize API, UI, and high-concurrency performance

Jan 9 · 3 min read · kiransabne.dev  
Updated Jul 11  
Read the article

-   [#databases](https://hashnode.com/tag/databases)
-   [#postgresql](https://hashnode.com/tag/postgresql)
-   [#sql](https://hashnode.com/tag/sql)
-   [#database-performance](https://hashnode.com/tag/database-performance)

## Written by

[kiran sabne](https://hashnode.com/@kiransabne)

@kiransabne

  
[View profile](https://hashnode.com/@kiransabne)

SQL Developer and Backend Developer

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
