Kirk Laurence Roybal

Allowing DML Operations in Highly Compressed Time-Series Data in PostgreSQL

3 Oct 2023 10 min read

We evolved our columnar compression design to comfortably allow data modifications, including INSERTs, UPDATEs, and DELETEs (DML operations).

What Does ChatGPT Know About Timescale?

19 Jun 2023 13 min read

We used ChatGPT to see how much it actually knows about Timescale.

Implementing ASOF Joins in PostgreSQL and Timescale

15 Jun 2023 4 min read

Read our step-by-step guide to implement ASOF joins in PostgreSQL and Timescale, and learn how to supercharge your queries with some Timescale magic.

How to Fix Transaction ID Wraparound Exhaustion

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 (Use it With Caution)

19 Jan 2023 8 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.

Timescale is a mature PostgreSQL cloud, specialized for your demanding workloads.

Time series and analytics

Vector (AI/ML) Early access

Dynamic Postgres Early access

Industries that rely on us

Timescale benchmarks