TigerData logo
TigerData logo
  • Product

    Product

    Tiger Cloud

    Robust elastic cloud platform for startups and enterprises

    TimescaleDB Enterprise

    Self-managed TimescaleDB for on-prem, edge and private cloud

    Open source

    TimescaleDB

    Time-series, real-time analytics and events on Postgres

    Search

    Vector and keyword search on Postgres

  • Industry

    Energy & Utilities

    Oil & Gas Operations

    Smart Manufacturing

    Crypto

  • Docs
  • Pricing
  • Developer Hub

    Changelog

    Benchmarks

    Blog

    Community

    Customer Stories

    Events

    Support

    Integrations

    Launch Hub

  • Company

    Contact us

    About

    TigerData logo

    Timescale

    Partners

    Security

    Careers

Start a free trial
Tiger Data

Products

  • TimescaleDB
  • Tiger Cloud
  • TimescaleDB Enterprise
  • Postgres Search Stack

Industry

  • Energy & Utilities
  • Oil & Gas Operations
  • Smart Manufacturing
  • Crypto

Support

  • Cloud Status
  • Support
  • Security
  • Terms of Service
  • Code Of Conduct

Learn

  • Documentation
  • Blog
  • Tutorials
  • Changelog
  • Success Stories

Company

  • About
  • Contact Us
  • Careers
  • Newsroom
  • Brand
  • Events

Products

  • TimescaleDB
  • Tiger Cloud
  • TimescaleDB Enterprise
  • Postgres Search Stack

Industry

  • Energy & Utilities
  • Oil & Gas Operations
  • Smart Manufacturing
  • Crypto

Support

  • Cloud Status
  • Support
  • Security
  • Terms of Service
  • Code Of Conduct

Learn

  • Documentation
  • Blog
  • Tutorials
  • Changelog
  • Success Stories

Company

  • About
  • Contact Us
  • Careers
  • Newsroom
  • Brand
  • Events
Privacy preferencesLegalPrivacySitemap

Subscribe to the Tiger Data newsletter

Gold Partner with Inductive Automation — Ignition

2026 (c) Timescale, Inc., d/b/a Tiger Data.
All rights reserved.

Tiger Data
GOLD PARTNER WITHINDUCTIVE AUTOMATION

2026 (c) Timescale, Inc., d/b/a Tiger Data.
All rights reserved.

Privacy preferencesLegalPrivacySitemap
Sven Klemm

Sven Klemm

Tiger Data Engineer

Introducing Direct Compress: Up to 40x Faster, Leaner Data Ingestion for Developers (Tech Preview)
Introducing Direct Compress: Up to 40x Faster, Leaner Data Ingestion for Developers (Tech Preview)

Announcements & Releases

TimescaleDB

Introducing Direct Compress: Up to 40x Faster, Leaner Data Ingestion for Developers (Tech Preview)

Direct Compress delivers up to 40x faster data ingestion for TimescaleDB by compressing time-series data in memory during insertion, eliminating background jobs.

By Sven Klemm

September 9th, 2025

Bridging the Gap Between Compressed and Uncompressed Data in Postgres: Introducing Compression Tuple Filtering
Bridging the Gap Between Compressed and Uncompressed Data in Postgres: Introducing Compression Tuple Filtering

PostgreSQL

Announcements & Releases

Bridging the Gap Between Compressed and Uncompressed Data in Postgres: Introducing Compression Tuple Filtering

Compressed data in Postgres now performs more like uncompressed data. Discover how we achieved up to 500x faster updates & deletes on compressed data.

By Sven Klemm

September 18th, 2024

Building Iterative Compression for Dynamic Applications
Building Iterative Compression for Dynamic Applications

Columnstore

Building Iterative Compression for Dynamic Applications

Streamlining data management? ✅ With TimescaleDB 2.14.0, you can change your compression settings on the fly to suit your data needs.

By Sven Klemm

March 4th, 2024

How We Fixed Long-Running PostgreSQL now( ) Queries (and Made Them Lightning Fast)
How We Fixed Long-Running PostgreSQL now( ) Queries (and Made Them Lightning Fast)

Announcements & Releases

PostgreSQL Performance

How We Fixed Long-Running PostgreSQL now( ) Queries (and Made Them Lightning Fast)

Help requests about slowdowns in PostgreSQL now( ) queries are a thing of the past. Learn how we fixed it in TimescaleDB 2.7 for lightning-fast performance (up to 400x faster!).

By Sven Klemm

June 22nd, 2022

Improving DISTINCT Query Performance Up to 8,000x on PostgreSQL
Improving DISTINCT Query Performance Up to 8,000x on PostgreSQL

PostgreSQL

PostgreSQL Performance

Improving DISTINCT Query Performance Up to 8,000x on PostgreSQL

Learn common performance pitfalls and discover techniques to optimize your DISTINCT PostgreSQL queries.

By Sven Klemm

May 6th, 2021

Achieving the Best of Both Worlds: Ensuring Up-To-Date Results With Real-Time Aggregation
Achieving the Best of Both Worlds: Ensuring Up-To-Date Results With Real-Time Aggregation

Product & Engineering

Engineering

Achieving the Best of Both Worlds: Ensuring Up-To-Date Results With Real-Time Aggregation

Real-time aggregates (released with TimescaleDB 1.7) build on continuous aggregates' ability to increase query speed and optimize storage. Learn what's new, details about how they work, and how to get started.

By Sven Klemm

May 7th, 2020

OrderedAppend: An Optimization for Range Partitioning
OrderedAppend: An Optimization for Range Partitioning

Product & Engineering

PostgreSQL

OrderedAppend: An Optimization for Range Partitioning

With this feature, we’ve seen up to 100x performance improvements for certain queries.

By Sven Klemm

July 31st, 2019

Implementing constraint exclusion for faster query performance
Implementing constraint exclusion for faster query performance

Product & Engineering

Implementing constraint exclusion for faster query performance

How we leveraged the foundation of PostgreSQL and extended its capabilities to improve performance.

By Sven Klemm

July 23rd, 2019

Mind the Gap: Using SQL Functions for Time-Series Analysis
Mind the Gap: Using SQL Functions for Time-Series Analysis

Product & Engineering

PostgreSQL

Mind the Gap: Using SQL Functions for Time-Series Analysis

Write more efficient and readable SQL queries with a new set of time-series analytic tools.

By Sven Klemm

January 24th, 2019

Stay updated with new
posts and releases.

Receive the latest technical articles and release notes in your inbox.