Kirk Laurence Roybal - Timescale Blog

How to Fix Transaction ID Wraparound in Postgres Databases

10 May 2023 9 min read

Learn more about transaction ID wraparound failure and how to avoid it in PostgreSQL databases. It involves treating your database as a house: turn on your Roomba, a.k.a. autovaccum.

The PostgreSQL Job Scheduler You Always Wanted (But Be Careful What You Ask For)

19 Jan 2023 7 min read

We created a job scheduler built into PostgreSQL with no external dependencies. This is the power you always wanted, but with a few caveats.

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.

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.

Database Scaling: PostgreSQL Caching Explained

13 Sep 2022 10 min read

shared_buffers are the second most important part of configuring (and scaling) your PostgreSQL instance. In the first of a series of posts, we start by explaining what they are and how they’re designed.