PostgreSQL 9. 0 High Performance : accelerateyour PosgreSQL system and avoid the common pitfalls that can slow it down /
Saved in:
| Main Author: | |
|---|---|
| Format: | Book |
| Language: | English |
| Published: |
Birmingham :
Packt Publishing,
2010.
|
| Edition: | First published |
| Series: |
Open source: community experience distilled
|
| Subjects: | |
| Notas Contenido: |
|
Table of Contents:
- PostgreSQL versions
- Database hardware
- Database hardware benchmarking
- Disk setup
- Memory for database caching
- Server configuration tuning
- Routine Maintenance
- Database benchmarking
- Database indexing
- Query optimization
- Database activity and statistics
- Monitoring and trending
- Pooling and caching
- Scalling with replication
- Partitioning data
- Avoiding common problems.