Products
Products
Time series and Real-Time Analytics
Lightning-fast ingest and querying on PostgreSQL.
Time series and Real-Time Analytics
AI and Vector
Build RAG, search, and Al agents, all on PostgreSQL.
AI and Vector
Deployment options & services
Timescale Cloud
A reliable PostgreSQL cloud for your workloads.
Timescale Cloud
Support Services
Support options for your use case, infrastructure, and budget.
Cloud support Self-managed support
Open-Source Extensions and Tools
Time Series and Real-Time Analytics
timescaledb timescaledb-toolkit
AI and Vector
pgai pgvectorscale
Security Scanner
pgspot
Solutions
Industries That Rely On Us
Crypto and finance Industrial IoT Energy Transportation and logistics
Featured Articles
Scale PostgreSQL via Partitioning: A Dev’s Intro to Hypertables
Read more
Scale PostgreSQL via Partitioning: A Dev’s Intro to Hypertables
Boosting Postgres INSERT Performance by 2x With UNNEST
Read more
Boosting Postgres INSERT Performance by 2x With UNNEST
Customers
Developers
Documentation
Timescale Docs
Learn how to make PostgreSQL faster with our documentation
Timescale Docs
AI and Vector
Learn how to use PostgreSQL for Al with our documentation
AI and Vector
Learn PostgreSQL
Learn PostgreSQL
Learn the PostgreSQL basics and scale your database performance
Overview Time series basics Postgres basics Postgres guides Benchmarks Postgres cheat sheet
Timescale Benchmarks
Timescale benchmarks
See how Timescale performs against the competition
vs RDS PostgreSQL vs Amazon Timestream vs Influx vs MongoDB vs ClickHouse vs Aurora vs Cassandra vs vanilla PostgreSQL
More
Blog
Tutorials
Support
Community
Changelog
GitHub
Slack
Forum
Launch Hub
Pricing

Log In Try for free

Home Time series basics Postgres basics Postgres guides Postgres best practices Postgres extensions Postgres for real-time analytics

Postgres overview

Understanding PostgreSQL Where Did PostgreSQL Come From?

Postgres clauses

Understanding FROM in PostgreSQL (With Examples)Understanding FILTER in PostgreSQL (With Examples)Understanding HAVING in PostgreSQL (With Examples)Understanding GROUP BY in PostgreSQL (With Examples)Understanding LIMIT in PostgreSQL (With Examples)Understanding ORDER BY in PostgreSQL (With Examples)Understanding WINDOW in PostgreSQL (With Examples)Understanding PostgreSQL WITHIN GROUP Understanding DISTINCT in PostgreSQL (With Examples)Understanding WHERE in PostgreSQL (With Examples)Understanding OFFSET in PostgreSQL (With Examples)

Postgres errors

How to Address ‘Error: Could Not Resize Shared Memory Segment’ 5 Common Connection Errors in PostgreSQL and How to Solve Them How to Fix No Partition of Relation Found for Row in Postgres Databases How to Fix Transaction ID Wraparound Exhaustion

PostgreSQL Joins : A Summary What Is a PostgreSQL Full Outer Join?What Is a PostgreSQL Cross Join?What Is a PostgreSQL Inner Join?What Is a PostgreSQL Left Join? And a Right Join?PostgreSQL Join Type Theory Strategies for Improving Postgres JOIN Performance

Postgres operations

A Guide to PostgreSQL Views Data Partitioning: What It Is and Why It Matters What Is Data Compression and How Does It Work?Self-Hosted or Cloud Database? A Countryside Reflection on Infrastructure Choices

Postgres functions

Understanding PostgreSQL Functions PostgreSQL Mathematical Functions: Enhancing Coding Efficiency Using PostgreSQL String Functions for Improved Data Analysis Data Processing With PostgreSQL Window Functions Understanding PostgreSQL Date and Time Functions Understanding the Postgres string_agg Function Understanding PostgreSQL Conditional Functions Understanding PostgreSQL Array Functions Understanding PostgreSQL's COALESCE Function Understanding PostgreSQL User-Defined Functions Understanding SQL Aggregate Functions Understanding the Postgres extract() Function Understanding percentile_cont() and percentile_disc() in PostgreSQL Understanding the rank() and dense_rank() Functions in PostgreSQL

Postgres statements

Understanding PostgreSQL SELECT What Characters Are Allowed in PostgreSQL Strings?

What Is Data Transformation, and Why Is It Important?

Understanding ACID Compliance Structured vs. Semi-Structured vs. Unstructured Data in PostgreSQL Understanding Foreign Keys in PostgreSQL

PostgreSQL Joins : A Summary

Abstract shapes over a black background.

SQL joins are used to combine rows from two or more tables based on a related column between them. There are four types of SQL joins: INNER JOINS (returns records with matching values in both tables), LEFT JOINS (returns all records from the left table, and matched records from the right table), RIGHT JOINS (returns all records from the right table, and matched records from the left table), and FULL JOINS (returns all records when there is a match in either the left or the right table).

Let’s dive into each of these and learn how to use them in PostgreSQL (and, of course, Timescale!).

Learn More About Join Strategies to Enhance Your Database Performance

Understanding how the PostgreSQL parser picks a join method can be valuable to define join strategies to enhance your database performance. To learn more about this topic and take your knowledge of joins to another level, check out this article on PostgreSQL Join Type Theory.