PostgreSQL

Timescale vs. Amazon RDS PostgreSQL: Up to 350x Faster Queries, 44 % Faster Ingest, 95 % Storage Savings for Time-Series Data

15 Nov 2022 13 min read

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

11 Nov 2022 11 min read

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

2 Nov 2022 8 min read

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 Caching: The Postmaster Process

23 Sep 2022 8 min read

On our second trip to PostgreSQL caching land, we continue explaining how shared_buffers work with the postmaster process.

PostgreSQL + TimescaleDB: 1,000x Faster Queries, 90 % Data Compression, and Much More

22 Sep 2022 15 min read

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.

Database Scaling: PostgreSQL Caching Explained

13 Sep 2022 10 min read

Caching is integral to improving PostgreSQL performance. A look at how caching works in PostgreSQL—and how to make it work even better.

How to Manage a PostgreSQL Commitfest

30 Aug 2022 12 min read

Most official docs on how to manage a PostgreSQL commitfest focus on the mechanics rather than the people. As this year’s PostgreSQL July Commitfest Manager, Jacob Champion shares his experience and some advice to other newcomers.

What Does a PostgreSQL Commitfest Manager Do and Should You Become One?

25 Aug 2022 5 min read

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.

Database Scaling: PostgreSQL Caching Explained

25 Aug 2022 10 min read

Caching is integral to improving PostgreSQL performance. A look at how caching works in PostgreSQL—and how to make it work even better.

What PostgreSQL Contributor Heikki Linnakangas Has to Say About the State of PostgreSQL 2022

29 Jul 2022 7 min read

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

26 Jul 2022 9 min read

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.

Postgres Materialized Views, The Timescale Way

14 Jul 2022 27 min read

Continuous aggregates are one of the most popular features in TimescaleDB, but you can’t fully understand them without some context on PostgreSQL views and materialized views.

State of PostgreSQL: How to Contribute to PostgreSQL and the Community

13 Jul 2022 7 min read

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.

State of PostgreSQL 2022—First Findings

8 Jul 2022 3 min read

The results of the third State of PostgreSQL survey are almost out! While you wait for the complete report, read some of the survey’s initial findings, including where PostgreSQL users come from, their experience level, and favorite tools.

What Is SQL Used For? To Build Environments Where Devs Can Experiment

5 Jul 2022 5 min read

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.