We're sorry but this page doesn't work properly without JavaScript enabled. Please enable it to continue.
Feedback

Performance and Scalability Enhancements in PostgreSQL 9.2

Formal Metadata

Title
Performance and Scalability Enhancements in PostgreSQL 9.2
Alternative Title
Performance Improvements in PostgreSQL 9.2
Title of Series
Number of Parts
20
Author
Contributors
License
CC Attribution - NonCommercial - ShareAlike 3.0 Unported:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal and non-commercial purpose as long as the work is attributed to the author in the manner specified by the author or licensor and the work or content is shared also in adapted form only under the conditions of this
Identifiers
Publisher
Release Date2012
LanguageEnglish
Producer

Content Metadata

Subject Area
Genre
Abstract
Bigger servers, bigger problems The upcoming PostgreSQL 9.2 release features a large number of performance enhancements by many different authors, including heavyweight lock manager improvements, reduced lock hold times in key hot spots, better group commit, index-only scans, better write-ahead log parallelism, sorting improvements, and a userspace AVC for sepgsql. In this talk I'll give an overview of what was changed, how it helped, lessons learned, and the challenges that remain.