One of the greatest features of Postgres is extensibility. In particular, extensions can help to dramatically improve performance troubleshooting capabilities. You can leverage built-in extensions or install from some third-party repositories managed by companies like Percona or EDB or simply install them from git sources.

One of the typical performance issues is when some process takes much longer than it used to take in the past. This post describes Top 5 extensions which can help with such retrospective analysis.

Continue reading “Enhancing PostgreSQL performance tuning capabilities” →