Author: Matt Pearson

Backup Tools for PostgreSQL

At conferences, the focus is always on innovative solutions. We forget to talk about the core tools that keep our databases functioning. This October, Matt Pearson – Pythian’s Database Consultant, will be evaluating the best backup tools for PostgreSQL.  Evaluating…

Read More >

Monitoring Transaction Logs in PostgreSQL


An important part of PostgreSQL monitoring is looking at how many transaction logs or WAL (Write Ahead Logs) files that are produced. WALs are produced as a part of the MVCC (MultiVersion Concurrency Control) that PostgreSQL uses. WAL ensures that…

Read More >