---
title: "Discussion on \"14,000x Faster Planning for LIMIT Queries on Hypertables\" | Hashnode"
description: "Discussion on \"14,000x Faster Planning for LIMIT Queries on Hypertables\". TimescaleDB's DeferredChunkAppend keeps planning time constant for ORDER BY LIMIT queries, no matter how many chunks a hypertable has."
url: "https://hashnode.com/posts/faster-planning-for-limit-queries-on-hypertables/6a9ac5f6247760f8da7d17d8"
---

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

Discussion

# [14,000x Faster Planning for LIMIT Queries on Hypertables](https://tigerdata.hashnode.dev/faster-planning-for-limit-queries-on-hypertables?utm_source=hashnode&utm_medium=feed)

TimescaleDB's DeferredChunkAppend keeps planning time constant for ORDER BY LIMIT queries, no matter how many chunks a hypertable has.

Sep 4 · 9 min read · tigerdata.hashnode.dev  
Read the article

-   [#databases](https://hashnode.com/tag/databases)
-   [#timescaledb](https://hashnode.com/tag/timescaledb)
-   [#postgresql](https://hashnode.com/tag/postgresql)

## Written by

[Tiger Data](https://hashnode.com/@tigerdata)

@tigerdata · New York, USA

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

Tiger Data, the creators of TimescaleDB, develops the open-source time-series database built on PostgreSQL and operates Tiger Cloud.

Tiger Data, the creators of TimescaleDB, develops the open-source time-series database built on PostgreSQL.

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
