Grafana with pg_stat_statements
In this post i describe an option to visualize the statement statistics collected by...
Partial Restore of a Table
Consider a case were you recognized that some entries in your production database are missing or...
GDPR Database Security – SSL Encryption
The General Data Protection Regulation (GDPR) is a regulation to strengthen and unify the data...
File Transfer between Ansible Nodes
Have you ever wanted to transfer files between different Ansible nodes and i do not mean between...
Monitoring PostgreSQL with Sensu
Sensu is a relative new Player in the Monitoring World. Upon now i’ve monitored my PostgreSQL...
Index-only Scan
Was andere Datenbank-Systeme, wie Mysql oder Oracle schon seit längerem unterstützen, ist seit...
IP-Adressen anonymisieren
Nach deutschem Datenschutzrecht ist die anlasslose Speicherung personenbezogener Daten unzulässig....
Index für LIKE-Abfragen optimieren
SELECT-Statements, welche LIKE in der WHERE-Clause nutzen, können einen Index benutzen, wenn...