# Paging Through a Parquet File in DuckDB: file_row_number vs Offset

The article compares two methods for paginating through Parquet files in DuckDB: using the file_row_number pseudo-column versus using an OFFSET clause. It explains the performance differences and best practices for efficient querying of partitioned datasets. This matters for developers working with large-scale data analytics in DuckDB.

**Importance:** 2/5

## Sources

### Technology
- [Hacker News](https://rusty.today/blog/paging-parquet-duckdb-file-row-number-vs-offset/) — Thu, 30 Jul 2026 14:58:07 +0000