# Adaptive Integer Compression in TimescaleDB: Built for the Read Path

DevFeed: [Adaptive Integer Compression in TimescaleDB: Built for the Read Path](<https://devfeed.tech/articles/adaptive-integer-compression-in-timescaledb-built-for-the-read-path-106829.md>)

Original publisher: [Read original article](<https://www.tigerdata.com/blog/adaptive-integer-compression-aic-in-timescaledb>)

Author: David Beck

Published: 2026-10-29T12:02:58Z

Content type: article

Language: en

Sources: [Timescale](<https://devfeed.tech/sources/timescale.md>)

Topics: [Compression](<https://devfeed.tech/topics/compression.md>), [Encoding](<https://devfeed.tech/topics/encoding.md>)

Tags: [adaptive](<https://devfeed.tech/tags/adaptive.md>), [compression](<https://devfeed.tech/tags/compression.md>), [encoding](<https://devfeed.tech/tags/encoding.md>), [fast](<https://devfeed.tech/tags/fast.md>), [foreign-keys](<https://devfeed.tech/tags/foreign-keys.md>), [integer-compression](<https://devfeed.tech/tags/integer-compression.md>), [query](<https://devfeed.tech/tags/query.md>), [small](<https://devfeed.tech/tags/small.md>), [sources](<https://devfeed.tech/tags/sources.md>), [status](<https://devfeed.tech/tags/status.md>), [tables](<https://devfeed.tech/tags/tables.md>), [time-series](<https://devfeed.tech/tags/time-series.md>), [timescaledb](<https://devfeed.tech/tags/timescaledb.md>)

## AI overview

Adaptive Integer Compression (AIC) selects an encoding for each block from options that decompress quickly. This addresses tables where integers include status codes, foreign keys, or interleaved sources, often arriving in small batches--data that DeltaDelta may not suit as well as time-series-shaped integers. The excerpt says queries reading this data must decompress it first; it does not provide performance measurements or describe the available encodings.

## Source excerpt

DeltaDelta suits time-series-shaped integers. Real tables also hold status codes, foreign keys and interleaved sources, often in small batches. Every query that reads that data has to decompress it first, so AIC picks the encoding per block, and only from encodings that decompress fast.