When talking to customers, sometimes I get the question: How should PostgreSQL installations deal with huge pages and large memory […]
Many people have heard that ALTER DEFAULT PRIVILEGES makes it easy to allow other users access to tables. But […]
Some time ago, I presented a typical approach to upgrade PostGIS under Ubuntu. Please take a look at my previous […]
Different from many other database systems, PostgreSQL does not support query hints. That makes it difficult to force the […]
This is a short war story from a customer problem. It serves as a warning that there are special […]
LZ4 and ZSTD pg_dump compression I wrote a "pg_dump compression specifications in PostgreSQL 16" post a while ago. Frankly speaking, […]
SQL and numeric constants NEW in PostgreSQL 16 - support for underscores in integer and numeric constants! I already wrote […]
A while ago, I wrote about how difficult it is to get an execution plan for a parameterized query. […]
What is a parallel aggregate? In PostgreSQL, a parallel aggregate refers to a way of processing aggregate functions (such as […]
The PostgreSQL documentation has some information about row locks. But typically, you cannot see them in pg_locks, and not […]
Naming variables Why will force_parallel_mode - the runtime option be renamed to debug_parallel_query in PostgreSQL 16? Proper variable and function […]
Archiving and database cleanup in PostgreSQL: Find out how DELETE and TRUNCATE compare in terms of performance and how the magic works
