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:


- 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 

Plaza BC
Thursday, February 19, 2015 - 14:30 to 15:30