This site is about a previous instance of this event. For the current event, please see the updated site.

Schedule - PGConf.EU 2014

Logical Decoding for Auditing

Date: 2014-10-24
Time: 11:50–12:40
Room: Renacimiento I
Level: Beginner

In this talk we demonstrate the new Logical Decoding features, 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

Speaker

Gianni Ciolli