Garantía de entrega
SKU/Artículo: AMZ-B0G6JH36WH
PostgreSQL DBA in Practice: Administration Handbook for PostgreSQL 15–17
Format:
Paperback
Detalles del producto
Disponibilidad:
En stock
En stock
Peso con empaque:
1.06 kg
1.06 kg
Devolución:
Sí
Sí
Condición
Nuevo
Nuevo
Producto de:
Amazon
Amazon
Viaja desde
USA
USA
Sobre este producto
- This book is a practical PostgreSQL DBA guide based on real-world administration experience for PostgreSQL 15–17.It comprehensively covers all aspects essential for operating PostgreSQL, from installation and environment setup to object management, understanding the architecture, configuring key parameters, physical and logical replication, backup and recovery, monitoring, and Vacuum. What is not covered in this book? This book does not cover optimization topics such as performance tuning or query tuning. Based on the author's actual PostgreSQL tuning project experience, this content is planned for a separate book. Who should read this book? This book is suitable for those who have 1-2 years of experience with PostgreSQL, or for those familiar with other DBMS but are just starting with PostgreSQL. Is this book not for everyone? This book targets PostgreSQL beginners or DBAs with limited practical experience. Therefore, it may be too basic for those already possessing deep expertise in PostgreSQL, and we do not recommend it for such readers. The difficulty level is beginner to intermediate, focusing on foundational and applied knowledge that can be directly applied in practice. What did you focus on most while writing the book? While writing this book, my primary focus was to provide practical content based on real-world experience that would genuinely assist DBAs in their work. Furthermore, through multiple rounds of editing, I refined and polished the expressions to ensure readers could more easily grasp the concepts I aimed to convey. Key concepts and operational principles are visually explained using over 40 illustrations, enabling readers to grasp complex topics more intuitively. How to Read This Book We recommend reading this book in order, starting from Chapter 1. Understanding the material covered earlier is essential for effectively learning subsequent content. Please type out the practice examples included in the book yourself whenever possible. Your skills will naturally improve through the process of typing them out, encountering errors, and resolving them through trial and error. However, the main scripts provided in Chapter 7 'Monitoring' can be downloaded via the GitHub link below. https://github.com/SiyeonAcademy/postgresql/blob/main/postgresql_script.zip Table of Contents 1. Environment Setup __1.1 Installation __1.2 Starting and Stopping Instances __1.3 Connect __1.4 Client Tools __1.5 Database Environment Setup 2. Objects __2.1 Tables __2.2 Indexes __2.3 Partitioning __2.4 Views __2.5 Sequences __2.6 Functions 3. Architecture __3.1 Instance __3.2 Tablespace __3.3 Tables __3.4 (Operational Tip) Template Database Feature 4. Parameter Configuration Guide __4.1 Logging-Related Parameters __4.2 Connection-Related Parameters __4.3 Memory-Related Parameters ...Omitted for brevity 5. Replication __5.1 Physical Replication __5.2 Logical Replication __5.3 Configuring a Daily Batch Environment Using Logical/Physical Replication ...Omitted for brevity 6. Backup and Recovery __6.1 Logical Backup and Recovery __6.2 Physical Backup and Recovery 7. Monitoring __7.1 Performance Monitoring Overview __7.2 Database Monitoring __7.3 Session Monitoring ...Omitted for brevity 8. Transactions and Wait Events __8.1 Transactions and Locks __8.2 Wait Events 9. Vacuum __9.1 The MVCC Model and Characteristics of PostgreSQL MVCC __9.2 Vacuum Basics __9.3 Key Parameters Related to Vacuum and Autovacuum __9.4 Slow Query Execution and Vacuum ...Omitted for brevity
S/ 218.28
60% OFF
S/ 87.30
IMPORT EASILY
By purchasing this product you can deduct VAT with your RUT number
S/ 218.28
60% OFF
S/ 87.30
Hasta 6 cuotas sin intereses con BCP, BBVA y Diners
Llega en 5 a 10 días hábiles
con envío
Tienes garantía de entrega
Compra protegida
Disfruta de una experiencia de compra segura y confiable
![]()
Garantía de entrega
Con Tiendamia todas tus compras cuentan con Garantía de Entrega o devolución total de tu dinero.
Compras 100% seguras y garantizadas, para que pidas lo que sueñas y lo recibas del mundo a tu puerta.
Saber más.
Visa
Mastercard
American Express
