PostgreSQL Performance Presentation (9.5devel edition)
Channel: Postgres Conference
Date: 2015-06-11

Check out http://www.pgconf.us/2015/event/89/ for the full talk details.

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:

- New index type called Block Range Indexes (BRIN)
- Improvements to the buffer cache management
- Improvements to the data lock management
- Other internal data structure changes

About the Speaker
Simon works as an Architect and Developer of new features for PostgreSQL, setting technical directions for 2ndQuadrant and as a Database Systems Architect for 2ndQuadrant customers. Simon is the author of PostgreSQL 9 Admin Cookbook.