LISTEN / NOTIFY: Automatic client notification in PostgreSQL
If 1000's of users constantly poll the database, a lot of load is caused for no benefit. LISTEN / NOTIFY is a better way, find out how.
PostgreSQL: Sequences vs. Invoice numbers
What's the problem with using PostgreSQL database side sequences to create unique invoice numbers to send to clients? Let's find out.
gexec in psql: PostgreSQL poweruser practice
gexec PostgreSQL poweruser practice: Learn how to use the gexec command and the `||` operator to get the best results out of your psql.
(Updated 2023-04-07) Even if you understand what a deadlock is, debugging deadlocks can be tricky. This article shows some […]
Case-insensitive pattern matching in PostgreSQL
by
Laurenz Albe |
06.2022 (Updated on 2024-11-27) Case-insensitive search is a much-requested feature, partly (I suspect) to maintain compatibility with Microsoft SQL […]
Next to character encoding, time zones are among the least-loved topics in computing. In addition, PostgreSQL's implementation of timestamp […]
Data Normalization in PostgreSQL
In his blog "Normalization by Osmosis", Michał Małecki gives you an overview of data normalization in PostgreSQL, including normal forms
PostgreSQL on WSL2 for Windows: Install and setup
UPDATE on 23.02.2023: This post explains how to install PostgreSQL on WSL2 for Windows, apply the necessary changes to PostgreSQL […]
Most database tables have an artificial numeric primary key, and that number is usually generated automatically using a sequence. […]
Creating and refreshing materialized views in PostgreSQL
A “materialized view” is an integral feature of every advanced database system. How can you make use of materialized views in PostgreSQL?