The LIMIT/OFFSET clause is off standard and thus not portable. Read about the proper way to handle it by using “SELECT … FETCH FIRST ROWS”.
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.
How to simulate unsupported out of the box temporal tables in PostgreSQL using delayed streaming replication and dblink extension
This post shows how to implement PostGIS setup on Ubuntu 20.04, how to install PostGIS packages & how to install extensions into database
Constraints over multiple rows: How to cope with complex PostgreSQL constraints. Advanced techniques - enforce integrity; manage concurrency.
Since v10, PostgreSQL has provided support for scram-sha-256 for password hashing and authentication. This article describes how you can […]
A “materialized view” is an integral feature of every advanced database system. How can you make use of materialized views in PostgreSQL?
For many people, “cross join” is something to be afraid of. They remember the time when they forgot the […]
Did you know PostgreSQL has the ability to synchronize sequential scans? If you are running data warehouses, you might have already used it without knowing.
When analyzing customer's problems, I have seen the mess you can get into if you disable autocommit in your […]
UPDATED Aug 2023: How to enable and disable autovacuum in PostgreSQL: How does autovacuum really work? Can you simply turn it on and off?
UPDATED July 2023: EXPLAIN ANALYZE is the key to optimizing SQL statements in PostgreSQL. This article does not attempt […]
