{"product_id":"postgresql-18-for-developers-and-dbas-practical-techniques-for-high-speed-queries-and-zero-downtime-upgrades-9798273424784","title":"PostgreSQL 18 for Developers and DBAs: Practical Techniques for High-Speed Queries and Zero Downtime Upgrades","description":"\u003cp\u003e • Author(s): Kate Daniel\u003cbr\u003e • Publisher: Independently Published\u003cbr\u003e • Publisher Imprint: Independently Published\u003cbr\u003e • BISAC: Languages - SQL\u003c\/p\u003e\u003cp\u003e\u003c\/p\u003e\u003cp\u003eWhat if you could upgrade your production databases with \u003cb\u003ezero downtime\u003c\/b\u003e, tune queries for \u003cb\u003emaximum throughput\u003c\/b\u003e, and harness PostgreSQL 18's new \u003cb\u003easynchronous I\/O engine\u003c\/b\u003e to make your workloads fly - all without guesswork?\u003c\/p\u003e\u003cp\u003e\u003ci\u003e\u003cb\u003ePostgreSQL 18 for Developers and DBAs\u003c\/b\u003e\u003c\/i\u003e 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.\u003c\/p\u003e\u003cp\u003eUnlike traditional documentation, this book focuses on \u003cb\u003ereal-world execution\u003c\/b\u003e - 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.\u003c\/p\u003e\u003cp\u003eYou'll discover how to: \u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e\u003cp\u003eExecute \u003cb\u003ezero-downtime upgrades\u003c\/b\u003e with pg_upgrade, logical replication, and fallback strategies.\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eTune and benchmark PostgreSQL 18's \u003cb\u003eAsynchronous I\/O subsystem\u003c\/b\u003e for NVMe and cloud storage.\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eOptimize queries using \u003cb\u003eskip-scan indexing\u003c\/b\u003e, \u003cb\u003euuidv7\u003c\/b\u003e, and \u003cb\u003evirtual generated columns\u003c\/b\u003e.\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eAutomate baselines, audits, and migrations using repeatable \u003cb\u003eCI\/CD-compatible workflows\u003c\/b\u003e.\u003c\/p\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cp\u003eSecure your clusters with \u003cb\u003eSCRAM\u003c\/b\u003e, \u003cb\u003eOAuth 2.0\u003c\/b\u003e, \u003cb\u003eTLS 1.3\u003c\/b\u003e, and \u003cb\u003echecksum-by-default\u003c\/b\u003e readiness.\u003c\/p\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eEvery concept is paired with tangible commands, code snippets, and operational recipes designed to make PostgreSQL 18 not just understandable - but deployable.\u003c\/p\u003e\u003cp\u003eIf you're a \u003cb\u003edeveloper\u003c\/b\u003e, \u003cb\u003eDBA\u003c\/b\u003e, or \u003cb\u003eDevOps engineer\u003c\/b\u003e ready to take PostgreSQL 18 from testbed to production - faster, safer, and smarter - this book is your blueprint.\u003c\/p\u003e\u003cp\u003e\u003cb\u003eMaster PostgreSQL 18. Eliminate downtime. Deliver performance that scales.\u003c\/b\u003e\u003c\/p\u003e","brand":"Independently Published","offers":[{"title":"Paperback","offer_id":48218233864343,"sku":"9798273424784","price":4221.0,"currency_code":"INR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0666\/3471\/1191\/files\/9798273424784.webp?v=1788743350","url":"https:\/\/atlanticbooks.com\/products\/postgresql-18-for-developers-and-dbas-practical-techniques-for-high-speed-queries-and-zero-downtime-upgrades-9798273424784","provider":"Atlantic Books","version":"1.0","type":"link"}