PGCon2008 - Final - we hope
PGCon 2008
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Jignesh K. Shah |
| Schedule | |
|---|---|
| Day | Talks - first day (2008-05-22) |
| Room | G |
| Start time | 15:00 |
| Duration | 01:00 |
| Info | |
| ID | 72 |
| Event type | lecture |
| Track | Hacker |
| Language | en |
| Feedback | |
|---|---|
|
Did you attend this event? Give Feedback |
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