Logging of data modifications and the “log_statement” configuration parameter
A short reminder on how PostgreSQL logs executed statements. Also included: a closer look at the log_statement parameter.
paginators - The story about voluntary pain in PostgreSQL
If you want to display millions of entries on your website, you definitely turn to paginators. Here's how you do it right using PostgreSQL.
PostgreSQL exclusion constraints: Beyond UNIQUE
UPDATED AUGUST 2023: A couple of years ago, PostgreSQL introduced so called “exclusion constraints”, which are defined with the EXCLUDE […]
BRIN indexes: Correlation, correlation, correlation
BRIN indexes have been introduced in PostgreSQL 9.5. While BRIN indexes are definitely a win, people tend to exaggerate and use them far too frequently.
Watch command - how to watch a PostgreSQL database
How to use the watch command: allows you to watch the program output change over time. It is therefore a perfect tool to track down errors.
Permissions: A little trickery
Learn how to use the INHERIT keyword in PostgreSQL, which allows a role to inherit permissions from another role. There is a catch, however.
By coincidence I noticed that psql can produce perfect LaTeX code. How cool is that? We show you how to do it, with examples.
Flexible grouping: Some dirty SQL trickery
How to group PostgreSQL data with some dirty SQL trickery. Find the difference between timestamps; how to use flexible grouping.
Fuzzy search solves the problem of spelling errors in searches. The goal is really to make sure that users have a chance - even with typos.
In PostgreSQL all major DDLs (CREATE TABLE, ...) are fully transactional. However, there are some exceptions.