Logical Decoding for Auditing

(Please notice that an updated version of this talk is available at this page)

In this talk we demonstrate the new Logical Decoding feature, introduced in PostgreSQL 9.4.

After a brief historical overview, we show how to apply Logical Decoding to the specific problem of auditing a database.

We also compare this solution to the more traditional approach, where triggers are created on those tables subject to auditing, evaluating in particular:
  • Simplicity
  • Performance
  • Separation between live data and audit data

Gianni Ciolli,
27 Oct 2014, 09:58