SKU/Artículo: AMZ-B0G1B8KBZ9

PostgreSQL 18 for Developers and DBAs: Practical Techniques for High-Speed Queries and Zero Downtime Upgrades

Format:

Paperback

Kindle

Paperback

Detalles del producto
Disponibilidad:
En stock
Peso con empaque:
0.48 kg
Devolución:
Condición
Nuevo
Producto de:
Amazon
Viaja desde
USA

Sobre este producto
  • What if you could upgrade your production databases with zero downtime, tune queries for maximum throughput, and harness PostgreSQL 18’s new asynchronous I/O engine to make your workloads fly — all without guesswork?PostgreSQL 18 for Developers and DBAs is the definitive hands-on guide to mastering the newest and most powerful version of PostgreSQL ever released. Written for practitioners who live and breathe databases, it bridges the gap between “what’s new” and “how to use it in production.” You’ll learn, step-by-step, how to perform major version upgrades safely, exploit the new AIO subsystem for faster reads, adopt UUIDv7 and virtual generated columns for better data modeling, and harden your environments with PostgreSQL 18’s enhanced security and compliance features.Unlike traditional documentation, this book focuses on real-world execution — with ready-to-run scripts, checklists, and benchmark-driven techniques validated across live systems. Whether you’re upgrading legacy clusters, tuning query performance, or building cloud-ready deployments, every chapter provides practical, measurable methods to improve reliability, scalability, and speed.You’ll discover how to:Execute zero-downtime upgrades with pg_upgrade, logical replication, and fallback strategies.Tune and benchmark PostgreSQL 18’s Asynchronous I/O subsystem for NVMe and cloud storage.Optimize queries using skip-scan indexing, uuidv7, and virtual generated columns.Automate baselines, audits, and migrations using repeatable CI/CD-compatible workflows.Secure your clusters with SCRAM, OAuth 2.0, TLS 1.3, and checksum-by-default readiness.Every concept is paired with tangible commands, code snippets, and operational recipes designed to make PostgreSQL 18 not just understandable — but deployable.If you’re a developer, DBA, or DevOps engineer ready to take PostgreSQL 18 from testbed to production — faster, safer, and smarter — this book is your blueprint.Master PostgreSQL 18. Eliminate downtime. Deliver performance that scales.
AR$126.129
31% OFF
AR$86.989

IMPORT EASILY

By purchasing this product you can deduct VAT with your RUT number

AR$126.129
31% OFF
AR$86.989

Pagá fácil y rápido con Mercado Pago o MODO

Llega en 8 a 12 días hábiles
con envío
Tienes garantía de entrega
Este producto viaja de USA a tus manos en