Announcements & Releases
How We Fixed Long-Running PostgreSQL now( ) Queries (and Made Them Lightning Fast)
Always Be Launching
Massive Scale for Time-Series Workloads: Introducing Continuous Aggregates for Distributed Hypertables in TimescaleDB 2.5
With this release, we introduce continuous aggregates in multi-node TimescaleDB, support for Postgres 14, and support for time zones in time_bucket_ng (under experimental).
Blog
What is ClickHouse, how does it compare to PostgreSQL and TimescaleDB, and how does it perform for time-series data?
An in-depth look at how ClickHouse and TimescaleDB architectures impact application design, developer experience, and performance - with detailed benchmark results comparing ingest speeds, disk space, and query response times.
Always Be Launching
Function Pipelines: Building Functional Programming Into PostgreSQL Using Custom Operators
Today we are releasing function pipelines, a new feature that allows you to analyze data by composing multiple functions in SQL - introducing a simpler, cleaner way of expressing complex logic in PostgreSQL.
Always Be Launching
Introducing Hyperfunctions: New SQL Functions to Simplify Working With Time-Series Data in PostgreSQL
TimescaleDB hyperfunctions are pre-built functions for the most common and difficult queries that developers write today in TimescaleDB and PostgreSQL. Hyperfunctions help developers measure what matters in time-series data, which generates massive, ever-growing streams of information.
Always Be Launching
Announcing Automated Disk Management: Safely Managing Your Cloud Database
To close out our final week of “Always Be Launching” month, we are announcing “Automated Full Disk Management” for Timescale Cloud, a new capability to ease operational overhead, protect against unforeseen overages, and keep your database up and running.
Always Be Launching
How I Learned to Stop Worrying and Love PostgreSQL on Kubernetes: Continuous Backup/Restore Validation on Timescale
Building a resilient cloud-native database experience means doing the hard stuff for our users. Learn how Timescale uses advanced techniques to ensure (and test for) reliability.
Observability
Promscale 0.4: Drawing Inspiration from Cortex to Rewrite Support for Prometheus High-Availability
Introducing Promscale 0.4 with new capabilities including better support for Prometheus high-availability, support for multi-tenancy, improved user permissions (using role-based access control), and more.
Always Be Launching
2021 State of PostgreSQL survey results
Postgres is one of the most popular and loved databases in the world, even after 30+ years of development. Learn how developers use Postgres today, from the use cases they’re tackling and places they go to share and learn to opportunities for improvement in the Postgres community, and more.
Always Be Launching
How we made DISTINCT queries up to 8,000x faster on PostgreSQL
We love PostgreSQL and believe in the power of the platform and community. Like all databases, sometimes "basic" queries don't scale with very large datasets. TimescaleDB 2.2 provides up to 8000x faster DISTINCT queries thanks in part to our ability to extend PostgreSQL.
