How to speed up GROUP BY statements in PostgreSQL. Follow some basic rules & you will squeeze performance out of the database for free.
fdw performance tuning - hidden tuning options which are not widely known. Let's see how to speed up the PostgreSQL foreign data wrapper.
Unaccent is a useful PostgreSQL extension for improving user experience. Get insight into this extension and its purpose.
Many people know that explicit table locks with LOCK TABLE are bad style and usually a consequence of bad […]
Pavel Stehule recently wrote the post "Don't use SQL keywords as PLpgSQL variable names" describing the situation when internal stored […]
UPDATE 12.07.2022: The “exclusive backup” method of calling pg_start_backup('label') before backup and pg_stop_backup() afterwards has been removed in PostgreSQL […]
Compare MySQL 8 and PostgreSQL for available features, general querying experience and documentation clarity.
Many databases such as Oracle provide "AS OF" queries (timetravel). This blog explains how to do time travel in PostgreSQL.
Feature Pack 4 of the PostgreSQL monitoring tool pgwatch2 is out. This article gives an overview about the new features and improvements.
pg_permissions is a tool display the security settings of your database. Get a quick overview of what's going on inside your security.
UPDATED August 2024 pgbouncer is the most widely used connection pooler for PostgreSQL. This blog will provide a simple cookbook […]
In this blog posting we will tell you more about how to use keywords exactly in PostgreSQL and e.g. what keywords may be used as object names
