Logical Decoding and Auditing

"Logical Decoding" is a very powerful feature introduced in PostgreSQL 9.4.

After a brief historical overview, we 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,
23 Mar 2015, 11:01