Pirozzi / Ahmed / Smith PostgreSQL 10 High Performance

Expert techniques for query optimization, high availability, and efficient database maintenance
3. Auflage 2018
ISBN: 978-1-78847-245-6
Verlag: De Gruyter
Format: EPUB
Kopierschutz: Adobe DRM (»Systemvoraussetzungen)

E-Book, Englisch, 508 Seiten

No detailed description available for "PostgreSQL 10 High Performance".

Autoren/Hrsg.

Pirozzi, Enrico

Ahmed, Ibrar

Smith, Gregory

Fachgebiete

• Mathematik | Informatik EDV | Informatik Technische Informatik Server
• Mathematik | Informatik EDV | Informatik Informatik Mensch-Maschine-Interaktion Informationsarchitektur
• Mathematik | Informatik EDV | Informatik Daten / Datenbanken Datenbankdesign & Datenbanktheorie

Inhaltsverzeichnis

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

- Scaling with Replication

- Partitioning Data
- Avoiding Common Problems

Über Autor(innen)

Pirozzi Enrico:

Enrico Pirozzi, EnterpriseDB certified on implementation management and tuning, with a master's in computer science, has been a PostgreSQL DBA since 2003. Based in Italy, he has been providing database advice to clients in industries such as manufacturing and web development for 10 years. He has been training others on PostgreSQL since 2008. Dedicated to open source technology since early in his career, he is a cofounder of the PostgreSQL Italian mailing list, PostgreSQL-it, and of the PostgreSQL Italian community site, PSQL