PostgreSQL
PostgreSQL + TimescaleDB: 1,000x Faster Queries, 90 % Data Compression, and Much More
TimescaleDB expands PostgreSQL query performance by 1,000x, reduces storage utilization by 90%, and provides time-saving features for time-series and analytical applications—while still being 100% Postgres.
PostgreSQL
State of PostgreSQL 2022—13 Tools That Aren't psql
Performance and tooling are frequently debated in the State of PostgreSQL survey, and this year was no exception. With psql remaining the number one tool for querying and admin among PostgreSQL users, we decided to compile a list of tools— that aren’t psql—to broaden your options.
PostgreSQL
State of PostgreSQL: How to Contribute to PostgreSQL and the Community
Community contribution remains a recurrent theme in the State of PostgreSQL survey. As we prepare to release the full report later this month, we dig into some of the results and leave you tips on how to contribute to PostgreSQL and its community.
Engineering
How We Made Data Aggregation Better and Faster on PostgreSQL With TimescaleDB 2.7
They’re so fast we can’t catch up! Check out our benchmarks with two datasets to learn how we used continuous aggregates to make queries up to 44,000x faster, while requiring 60 % less storage (on average).
PostgreSQL
How to Create (Lots!) of Sample Time-Series Data With PostgreSQL generate_series()
Generating sample time-series data with the PostgreSQL generate_series() function is a useful skill to have when evaluating new database features, creating demonstrations, or testing insert and query patterns. Learn what PostgreSQL `generate_series()` is and how to use it for basic data generation.
General
Hacking NFL data with PostgreSQL, TimescaleDB, and SQL
Learn how to use time-series data provided by the NFL to uncover valuable insights into many player performance metrics – and ways to apply the same methods to improve your fantasy league team, or your knowledge of the game - all with PostgreSQL, SQL, and freely available extensions.
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.
Announcements & Releases
TimescaleDB vs. Amazon Timestream: 6,000x Higher Inserts, 5-175x Faster Queries, 150-220x Cheaper
Our TimescaleDB vs Amazon Timestream results surprised us, but even after testing several configurations, we found Timestream slow, expensive, and missing key database capabilities like backups, restores, updates, and deletes.