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.
Regular expressions unleashed in PostgreSQL
How to use an operator to work with regular expressions in PostgreSQL: includes list and a case-sensitive example. Fun with coding PostgreSQL
Fed up with long WHERE-clauses?
What if you want to compare dozens of columns with each other in PostgreSQL? Find out how to do it right here.
Making random() deterministic - random generator in PostgreSQL
How to reproduce a random sequence of numbers. Reset the random generator to restart a certain value in PostgreSQL. random()
PostgreSQL: Finding Christmas presents
In this blog we are talking about KNN-search. KNN-search has been made for finding something close to what you are looking for.
Operator classes explained
In this blog we are tallking about the topic operator class. We will show you some strategies for your database.
CREATE DOMAIN: Data type abstraction
In a procedural language such as C people will create typedefs & functions But what about data type abstraction in SQL?
Per-tablespace storage parameters
A per-tablespace can be used to add more hardware to the system – but, is there some other way to make use of a tablespace? There is!
