An Intro to Data Modeling on PostgreSQL

Explore the essential aspects of PostgreSQL data modeling, its essential attributes and benefits, and learn practical tips for seamless implementation. 

Database Partitioning: What It Is and Why It Matters

Database partitioning is a technique used to divide a large database into smaller, more manageable pieces called partitions. Learn why data partitioning is important, how it works, and its types. Plus, read strategies to improve Postgres partitioning.

What Is Data Compression and How Does It Work?

Data compression is the process of reducing the size of digital data while preserving the essential information contained in them. Learn more about data compression, its types, and why it's so important.

Building a Scalable Database

Learn what a scalable database is and how you can actually scale PostgreSQL through design practices.

Do You Have Time-Series Data?

Time-series data is a type of data that is collected and recorded over a period of time. Read this article and find out if you're working with time-series data.

Beyond the Basics: Exploring PostgreSQL Extensions

In this page, we delve into PostgreSQL extensions: from performance optimization to adding specialized features, we cover it all.

PostgreSQL Extensions: Turning PostgreSQL Into a Vector Database With pgvector

pgvector is a PostgreSQL extension that provides powerful functionalities for working with vectors in a high-dimensional space. Learn how to use it to query and analyze vector data alongside other structured data.

PostgreSQL Extensions: pg_prewarm

​pg_prewarm is a PostgreSQL extension that allows developers to load relation data into either the operating system's buffer cache or PostgreSQL's shared buffers. Learn more about it.

Understanding PostgreSQL Functions

This guide will provide you with a list of PostgreSQL built-in functions, complete with brief descriptions, code snippets, and Timescale custom SQL queries that will take your data analysis to another level.

SQL Joins : A Summary

SQL joins are used to combine rows from two or more tables based on a related column between them. Let’s learn how to use them in PostgreSQL (and, of course, Timescale!).

What Is PostgreSQL and Where Did It Come From

PostgreSQL is now a fully matured database solution with all the bells and whistles. Let’s talk about our favorite open-source relational database.

A Guide to PostgreSQL Views

An introduction to standard PostgreSQL views and materialized views, how to use each of them, and how to create them.

PostgreSQL Join Type Theory

How does the PostgreSQL parser chooses which JOIN types to use? JOIN us for a session on JOIN theory.

PostgreSQL Materialized Views and Where to Find Them

Learn more about using Timescale’s alternative to a PostgreSQL materialized view.

vs RDS

Since we launched Timescale, our cloud-hosted PostgreSQL service for time-series data and event and analytics workloads, we have seen large numbers of customers migrating onto it from the general-purpose Amazon RDS for PostgreSQL.

vs Amazon Timestream

This post compares TimescaleDB and Amazon Timestream across quantitative and qualitative dimensions.

vs Influx

An in-depth look into how two leading time-series databases stack up in terms of the data model, query language, reliability, performance, ecosystem, operational management, and company/community support.

vs Cassandra

In this post, we dig deeper into using Cassandra vs. TimescaleDB for time-series workloads by comparing the scaling patterns, data model complexity, insert rates, read rates, and read-throughput of each database

vs MongoDB

Time-series data has exploded in popularity, and the value of tracking and analyzing how things change over time has become evident in every industry

vs ClickHouse

In this detailed post, which is the culmination of three months of research and analysis, we answer the most common questions we hear, including