Profiling PostGIS with PLProfiler
PLProfiler is a great tool for profiling PL/PGSQL functions, but you need an extra trick for PostGIS native functions.
Performance
Managing the Performance of Grafana/Prometheus Dashboards using Nginx & Lua
Regain visibility into the performance of Open Source Grafana and Prometheus so you know which dashboards and visualisations are slowing down your Prometheus service.
Point a single process to /dev/urandom instead of /dev/random
Giving a single process (tree) a different view of the filesystem without modifying the process; and showing how to do this manually and via Ansible.
NFS Lock Analysis with tshark (Wireshark) and Python
NFS locking can impede the performance of your clustered application. Learn how to capture and analyse NFS traffic to see where your locking issues are.