Carlota Soto

Compression Faceoff: Postgres TOAST vs Timescale Compression

29 Nov 2023 10 min read

PostgreSQL TOAST vs. Timescale compression: read the comparison and learn why TOAST is not the most effective database compression mechanism.

Building Columnar Compression for Large PostgreSQL Databases

14 Nov 2023 24 min read

Read how we built a flexible, high-performance columnar compression mechanism for PostgreSQL to add scalability to our favorite database.

Scaling PostgreSQL for Cheap: Introducing Tiered Storage in Timescale

13 Nov 2023 13 min read

Data management decisions don’t have to be costly. Introducing Tiered Storage, a low-cost infinite storage tier for your historical data needs.

Navigating a Usage-Based Model for PostgreSQL: Tips to Reduce Your Database Size

7 Nov 2023 11 min read

Usage-based models demand higher accountability for how you manage your data. Learn tips to reduce your Postgres database size.

What Is TOAST (and Why It Isn’t Enough for Data Compression in Postgres)

25 Oct 2023 10 min read

Postgres TOAST is often seen as a data compression mechanism in PostgreSQL, but it falls short of that task. Learn how TOAST really works and why there is a better alternative.

Database Backups and Disaster Recovery in PostgreSQL: Your Questions, Answered

24 Oct 2023 14 min read

Database backups are one of the biggest pain points for developers. Learn how you can keep your PostgreSQL database safe.

How to Reduce Your PostgreSQL Database Size

6 Oct 2023 12 min read

Optimizing the storage used by your PostgreSQL database will help keep your costs low and improve the performance of your large tables.

What InfluxDB Got Wrong

5 Oct 2023 10 min read

A reflection on what InfluxDB got wrong with its past releases—from one database company to another.

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).

Estimating RDS Costs

20 Jul 2023 8 min read

Estimating RDS costs can be tricky. Here’s how to avoid sticker shock when your AWS hosting bill comes due.

Savings Unlocked: Why We Switched to a Pay-For-What-You-Store Database Storage Model

29 Jun 2023 7 min read

Efficient, scalable, and flexible database storage? We're in! Learn about our new usage-based pricing model, and pay only for what you store.

Understanding RDS Pricing

12 Apr 2023 7 min read

AWS pricing can often be opaque. This is especially true of RDS. Here’s how to understand RDS pricing and estimate your spending.

How to Turn Timescale Into an Observability Backend With Promscale

14 Dec 2022 15 min read

Learn everything you need to know about how to integrate Timescale Cloud and Promscale with a Kubernetes-based system, including how to optimally configure Prometheus, OpenTelemetry, Grafana, and Jaeger, and how you can use SQL to analyze your metrics and traces.