Tech preview: How PostgreSQL 12 handles prepared plans
Get the chance to control the behavior of the PostgreSQL optimizer | Handling Prepared plans in PostgreSQL 12
COPY command and bulk loading in PostgreSQL 12
COPY command in PostgreSQL 12: I will now point to the correct page in the documentation and COPY now supports a WHERE condition
PostgreSQL: Using CREATE USER with caution
There are good reasons why CREATE USER should be used cautiously. Find out why, and why you should distinguish between users and roles.
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.
