PostgreSQL Day

Mon, 2015-01-05 09:37

Logical Decoding and Auditing

Logical Decoding" is the cryptic name for 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

Tue, 2014-11-25 14:30

PostgreSQL Performance Presentation (9.5devel edition)

This presentation will take a look at the performance changes in the development version of PostgreSQL. A selection of features, some proposed and some already committed, are evaluated using synthetic open source workloads. One of the workloads used is the former OSDL's Database Test 3 that consists of business oriented ad-hob queries with concurrent data modification.

Some of these proposed features include:

Sat, 2014-11-22 00:32

Explaining the Postgres Query Optimizer

The optimizer is the "brain" of the database, interpreting SQL queries and determining the fastest method of execution. This talk uses the explain command to show how the optimizer interprets queries and determines optimal execution. The talk will assist developers and administrators in understanding how Postgres optimally executes their queries and what steps they can take to understand and perhaps improve its behavior.

Subscribe to PostgreSQL Day