DECLARE CURSOR in PostgreSQL or how to reduce memory consumption
This blogpost is about using cursors in PostgreSQL, their purpose and limitations and what DECLARE CURSOR and FETCH have to do with it.
Speeding up GROUP BY in PostgreSQL
How to speed up GROUP BY statements in PostgreSQL. Follow some basic rules & you will squeeze performance out of the database for free.
Foreign data wrapper for PostgreSQL: Performance Tuning
fdw performance tuning - hidden tuning options which are not widely known. Let's see how to speed up the PostgreSQL foreign data wrapper.
unaccent: Getting rid of umlauts, accents and special characters
Unaccent is a useful PostgreSQL extension for improving user experience. Get insight into this extension and its purpose.
Implementing “AS OF”-queries in PostgreSQL
Many databases such as Oracle provide "AS OF" queries (timetravel). This blog explains how to do time travel in PostgreSQL.
pg_permissions: Inspecting your PostgreSQL security system
pg_permissions is a tool display the security settings of your database. Get a quick overview of what's going on inside your security.
A PostgreSQL story about "NULL IS NULL = NULL AND NOT NULL"
Why the word "unknown" is better to describe a NULL value than "empty". Learn to use NULL values correctly in PostgreSQL.
Transactions in PostgreSQL: READ COMMITTED vs. REPEATABLE READ
How to use the two most common transaction isolation levels in PostgreSQL: READ COMMITTED and REPEATABLE READ.
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?
PostgreSQL: Parallel CREATE INDEX for better performance
How to use parallel CREATE INDEX in PostgreSQL, which will eliminate various performance bottlenecks - especially for large applications.