PGCon2008 - Final - we hope
PGCon 2008
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Fernando Ike |
| Schedule | |
|---|---|
| Day | Talks - second day (2008-05-23) |
| Room | G |
| Start time | 15:00 |
| Duration | 01:00 |
| Info | |
| ID | 90 |
| Event type | lecture |
| Track | DBA |
| Language | en |
| Feedback | |
|---|---|
|
Did you attend this event? Give Feedback |
Researching PostgreSQL Performance
Results from different OS and FS
In this talk, we will present a detailed analysis of the scenarios tested (different loads and number of users). Furthermore, measurements reflecting improvements in the newer PostgreSQL version will be summarized.
How do we tune PostgreSQL? There is no cake recipe. The default configuration is far from being good to a high-end hardware. The problem is that it's hard to find a good configuration for different database designs. Thinking about it, we did a research aimed to test dozens of available operating system and DBMS parameters, and different filesystems. It was used 64-bit multiprocessor Linux plataforms and a fiber channel SAN.
In this talk, we will present a detailed analysis of the scenarios tested (different loads and number of users). Furthermore, measurements reflecting improvements in the newer PostgreSQL version will be summarized.