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.
SQL Isn’t That Hard (When You Don’t Approach It From an Object-Oriented Point of View)
John Pruitt first learned SQL at university, but his first interaction with computers dates back to 1986 when he was only four. His one tip for learning SQL? Do not approach it from an object-oriented programming point of view.