PGCon2008 - Final - we hope

PGCon 2008
The PostgreSQL Conference

Jignesh K. Shah
Day Talks - first day (2008-05-22)
Room G
Start time 15:00
Duration 01:00
ID 72
Event type lecture
Track Hacker
Language en

Problems with PostgreSQL on Multi-core Systems with Multi-Terabyte Data

Using customer feedback and benchmarks to reduce performance and productivity loss

As multi-core systems and storage space become cheaper, PostgreSQL is increasingly hard pressed to scale to the size of servers available to most users. Sun's performance engineers use customer feedback and industry standard benchmarks like TPC-E and SpecJAppserver to examine what causes these issues and what to do about them.

Sun has a small performance engineering team devoted to PostgreSQL scalability. For the past year, this team has been working on making PostgreSQL scale to more cores and larger databases, both to satisfy customer demand, and to improve benchmark scores. This session will cover their findings on PostgreSQL scalability and suggest ways to improve PostgreSQL 8.4 in order to make it scale to twice as many cores and terabytes as 8.3 did -- as well as beat the scalability-destroying TPC-E benchmark.

Areas covered:

  • Setup,loading, utilities
  • ProcArrayLock problem for OLTP workload
  • Load, Index Build, Backup Restore for DSS Workloads
  • Discuss ideas on what can be done