Timescale Newsletter ?? Making PostgreSQL Faster
Hi friends,?
This is the second time we’re popping up in your inbox this week, but we promise it’s for a good reason!
Perhaps you’ve already noticed that we wrapped up an entire week of announcements dedicated to the performance improvements in TimescaleDB 2.16.0. As always, our North Star was to make PostgreSQL faster, fiercer, and more flexible so you can use it for an even wider range of use cases, including real-time analytics.
So join us on this recap as we walk you through all the new updates, from a consolidated hybrid row-columnar storage engine and chunk-skipping indexes to compression tuple filtering, faster upserts on compressed data, and much faster query performance on tiered data. Oh, and have we told you how we’re scaling PostgreSQL to the petabyte scale? ?? (Spoiler alert: all you need is a vanilla Timescale Cloud instance.)
See you soon! ??
P.S. In case you missed it, the most clicked link in the previous edition was the Timescale Blog! We asked you to keep an ??? out for updates, and you did!
Hot Off the Press
FEATURED POST
Making PostgreSQL Faster: New Features for 7x Faster Queries and 500x Faster Updates
Learn more about hypercore and how we’re enabling PostgreSQL to manage real-time analytics workloads with greater performance and cost optimizations. Read more
A Hybrid Row-Columnar Storage Engine for Time Series Real-Time Analytics
Optimized PostgreSQL for time series? Sure! But TimescaleDB is more than that. See how we improved our hybrid row-columnar storage engine to solve our customers’ real-time analytics needs. Learn more
Boost PostgreSQL Performance by 7x With Chunk-Skipping Indexes
See how we made PostgreSQL performance 7x faster while using 87 % less storage thanks to smarter partition pruning via chunk-skipping indexes. Learn more
Bridging the Gap Between Compressed and Uncompressed Data in PostgreSQL: Introducing Compression Tuple Filtering
Compressed data in PostgreSQL now performs more like uncompressed data. ?? Discover how we achieved up to 500x faster updates and deletes on compressed data. Read more
How We Made PostgreSQL Upserts 300x Faster on Compressed Data
A customer use case inspired us to make upsert performance 300x faster on compressed data by moving from PostgreSQL sequential scans to index scans. Learn more
领英推荐
Scaling PostgreSQL to Petabyte Scale
PostgreSQL, but make it petabyte scale. ?? Read how we’re scaling PostgreSQL to manage petabytes of data and power our query monitoring feature, Insights. Learn more
Boosting 400x Query Performance for Tiered Data on S3 in PostgreSQL
Read how we made query performance up to 400x faster over tiered data on S3. You can now query cold data much quicker while keeping your storage costs down. Read more
Sharing the ??
Thanks to all of you who took the time to spread the Timescale love online! We are incredibly grateful to be part of this wonderful community!
Hey, have you taken the 2024 State of PostgreSQL survey?
Share your feedback, favorite extensions, community experiences, and more. The survey closes September 30 at 11:59 p.m. PT. Take it now!
Timescale Careers
Team Timescale is growing! If you know someone who'd like to join our team—or learn more about life on Team Timescale ??—we're currently hiring (100 percent remote).?
?? Was this newsletter forwarded to you? Opt in to receive our newsletter and get these updates straight to your inbox!