Subqueries and performance in PostgreSQL
by
Laurenz Albe |
07.2023 SQL allows you to use subqueries almost anywhere where you could have a table or column name. All you […]
Different from many other database systems, PostgreSQL does not support query hints. That makes it difficult to force the […]
What is an inner join in SQL? And what is an outer join?
Joins: Learn how to use an inner join and an outer join in PostgreSQL today by reading our tutorial. Also covers semi and full joins.
Understanding LATERAL joins in PostgreSQL
LATERAL joins are extremely useful & can be utilized in many cases to speed up operations, or to simply make code a lot easier to understand.
For many people, “cross join” is something to be afraid of. They remember the time when they forgot the […]
Join strategies and performance in PostgreSQL
by
Laurenz Albe |
06.2020 (Updated 2023-02-24) There are three join strategies in PostgreSQL that work quite differently. If PostgreSQL chooses the wrong strategy, […]
PostgreSQL: Implicit vs. explicit joins
How to use implicit and explicit joins in PostgreSQL. What are the performance differences between these two types of join?
Joining data from multiple Postgres databases
How to join or search data from multiple independent PostgreSQL databases to present it as one logical entity. Here are 4 methods.
int4 vs int8 vs uuid vs numeric performance on bigger joins
Brief overview of the performance of different datatypes on bigger joins. How much performance gets lost? Which one is better? Have a look!
Two simple Postgres tips to kick-start the year 2017
Let's start the new year with some PostgreSQL trickery. We present you with two nice PostgreSQL tricks that are really useful.
