PostgreSQL Performance Presentation (9.5devel edition)
Presented by:
Mark Wong
Mark works at 2ndQuadrant as a consultant for English Speaking Territories, based out of Oregon. He is a Contributor to PostgreSQL, co-organizer of the Portland PostgreSQL User Group, and serves as a Director and Treasurer for the United States PostgreSQL Association.
No video of the event yet, sorry!
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
- Date:
- Duration:
- 30 min
- Room:
- Conference:
- PGConf US 2015 [PgConf.US]
- Language:
- Track:
- Performance
- Difficulty:
- Medium