Naming temporary tables properly in PostgreSQL
What if a temporary table in PostgreSQL has the same name as a “real” table? What happens? Find out about naming temporary tables properly.
DROP TABLE: Killing shared_buffers
UPDATED August 2023: How to tune shared buffers - when it is large, PostgreSQL performance issues may result: what to do to fix the problem.
PostgreSQL 9.4 aggregate filter clauses: They do pay off
In this blog ppost we cover the impact of aggregate FILTER clauses have on performance. Find out more about aggregation filters.
Partial aggregation: The beautiful way
Partial aggregation: Functions such as min, max, count, sum, avg and so on are used in virtually every application. Find out more.
Managing backup speed with pg_basebackup
How to adjust backup speed when using pg_basebackup in PostgreSQL. What if the I/O capacity of servers is low & network bandwidth is large?
Analytics: Lagging entire rows
There is a PostgreSQL feature in the area of analytics which is not widely known: the power to use composite data types along with analytics.
walbouncer: Filtering the transaction log
You might not want to replicate all data to your standbys. walbouncer can filter the transaction log, & replicate only the data needed.
Killing proper indexing: A neat idea
There are a couple of ways to kill indexing entirely. One of this ways is to apply functions or expressions. Read out in our blog.
Next stop: Joining 1 million tables
This week I started my preparations for one of my talks in Madrid. The topic is: "Joining 1 million tables". […]
Checking per-memory context memory consumption
Internally PostgreSQL makes use of so called “memory contexts”. What is the idea and what are the advantages? Find out here.