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.
What hot_standby_feedback in PostgreSQL really does
How to avoid streaming replication conflicts with hot_standby_feedback and VACUUM. Improve your replication setup and prevent failure.
