The State of PostgreSQL Database 2015

(presented at 5 4 3 2... MeetUs! Milan, 12-13 May 2015: please notice that an updated version of this talk is available at this page)

In this talk we present the latest news from the PostgreSQL database project, including an overview of features from the most recent production releases (9.4) and development releases (9.5, up to the day of the conference!).

In a separate section we also cover interesting features introduced in previous versions, so this talk can be of interest for both the newcomer and the experienced user.

Features covered in this presentation include:

  • Background Workers
  • Disaster Recovery
  • PostgreSQL Externalities
  • Foreign Data Wrappers
  • Functions and Languages
  • Logical Decoding
  • Materialised Views
  • Open Source-ness
  • Portability
  • PostgreSQL versions
  • Replication
  • Row-Level Security
  • Transactions
  • Various concurrency improvements
  • Various index types
  • Various performance improvements
  • XML, JSON, and related improvements
Gianni Ciolli,
20 May 2015, 10:33