



Best Practices for Time-Series Data Modeling: Single or Multiple Partitioned Table(s) a.k.a. Hypertables
Time-series data is relentless, so you know you’ll have to create one or more partitioned tables (a.k.a. Timescale hypertables) to store it. Learn how to choose the best data modeling option for your use case—single or multiple hypertables.

A PostgreSQL Developer’s Perspective: Five Interesting Patches From January’s Commitfest
In this recap of January’s Commitfest, our PostgreSQL developer Chris Travers shares his thoughts on improvements to psql, software development with infinite values, transaction ID wraparound problems, and more.







Timescale vs. Amazon RDS PostgreSQL: Up to 350x Faster Queries, 44 % Faster Ingest, 95 % Storage Savings for Time-Series Data
Why are developers migrating from Amazon RDS for PostgreSQL to Timescale to handle their time-series data workloads? Our benchmark answers the question: faster queries, faster ingest, and 95 % storage savings for time-series data.

Read Before You Upgrade: Best Practices for Choosing Your PostgreSQL Version
PostgreSQL upgrades have been known to be a bit of a controversial issue in the community. In this article, we will take the mystery out of the question of when an upgrade is appropriate and how Timescale allows you to do it as swiftly as possible.

A PostgreSQL Developer's Perspective: Five Interesting Patches From September's Commitfest
Welcome to our new blog series! Every other month, Timescale’s developer advocate, Chris Travers, will use his PostgreSQL developer perspective to feel the pulse of the beloved database by looking into new commitfest patches.


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.



What Does a PostgreSQL Commitfest Manager Do and Should You Become One?
Having been a PostgreSQL Commitfest Manager earlier this year, Timescaler and PostgreSQL contributor, Jacob Champion, shares his recommendations for those who would like to take on the same role and explains what it entails.

What PostgreSQL Contributor Heikki Linnakangas Has to Say About the State of PostgreSQL 2022
PostgreSQL celebrates its 25th birthday this year. For a deeper look into its community, we asked PostgreSQL developer and committer Heikki Linnakangas to comment on the survey results of the newly released State of PostgreSQL 2022 report. Here’s what he had to say.

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.


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.


What Is SQL Used For? To Build Environments Where Devs Can Experiment
Nikolay Samokhvalov not only solves problems with SQL but also assists others in doing so. In this interview, he shares the coolest thing he did with SQL, how he is building environments where devs can experiment with SQL, and advice on keeping your knowledge up to date.