{"product_id":"9788119177523","title":"PostgreSQL 17 QuickStart Pro: Add expertise around WAL processing, JSON table, IO performance, logical replication and index vacuuming","description":"\u003cp\u003ePostgreSQL 17 QuickStart Pro is the definitive hands-on, practical book for professionals at every level, from entry-level administrators to seasoned experts. It provides \u003cstrong\u003erapid learning and practical implementation of PostgreSQL 17\u003c\/strong\u003e, focusing on the latest features and best practices to effectively manage, configure, and optimize PostgreSQL databases-and it does so effectively.\u003c\/p\u003e\u003cp\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003eThe book begins by \u003cstrong\u003eusing the Titanic dataset \u003c\/strong\u003eto illustrate practical examples of \u003cstrong\u003eupgrade strategies, post-upgrade validation, and database configuration\u003c\/strong\u003e. Next, it covers \u003cstrong\u003ecluster administration, configuration settings, and performance tracking\u003c\/strong\u003e. You will master the \u003cstrong\u003emanagement of permissions and roles through intricate role hierarchies, authentication methods, and security settings\u003c\/strong\u003e. Next, we'll \u003cstrong\u003eoptimize server performance, plan queries, and manage resources based on real performance data\u003c\/strong\u003e.\u003c\/p\u003e\u003cp\u003e\u003cbr\u003e\u003c\/p\u003e\u003cp\u003eThe next section dives deep into \u003cstrong\u003ecomplicated data types, bulk data operations, advanced indexing methods, and the creation of triggers and functions\u003c\/strong\u003e, all with an emphasis on effective data management. Next, you will learn about \u003cstrong\u003etable partitioning strategies, performing physical and logical backups, database restoration, and process automation using BART\u003c\/strong\u003e. We then move on to \u003cstrong\u003estreaming replication, where we will configure, administer, and monitor replication to ensure optimal uptime\u003c\/strong\u003e. Finally, we will explore \u003cstrong\u003epoint-in-time recovery (PITR)\u003c\/strong\u003e, which allows us to restore databases to specific points in time by \u003cstrong\u003ereplaying WAL logs\u003c\/strong\u003e. In short, this book will equip database administrators with the knowledge and skills to confidently handle PostgreSQL 17 databases.\u003c\/p\u003e\u003cp\u003e\u003cbr\u003e\u003c\/p\u003eKey Learnings\u003cp\u003eUpgrade and configure PostgreSQL 17, including post-upgrade validation and configuration.\u003c\/p\u003e\u003cp\u003eLearn PostgreSQL architecture, memory models, and cluster management.\u003c\/p\u003e\u003cp\u003eUse hierarchical permissions, authentication, and security for advanced role management.\u003c\/p\u003e\u003cp\u003eTune server performance with query planning, resource management, and configuration tuning.\u003c\/p\u003e\u003cp\u003eEffectively use PostgreSQL extensions, JSONB, and arrays.\u003c\/p\u003e\u003cp\u003eOptimize queries with GIN, GiST, and BRIN indexing.\u003c\/p\u003e\u003cp\u003eMaster table partitioning for large dataset performance and scalability.\u003c\/p\u003e\u003cp\u003eAutomate physical and logical backups and confidently restore databases.\u003c\/p\u003e\u003cp\u003eManage PostgreSQL streaming replication for high availability and automatic failover.\u003c\/p\u003e\u003cp\u003eRestore data using WAL logs and Point-in-Time Recovery.\u003c\/p\u003e\u003cp\u003e\u003cbr\u003e\u003c\/p\u003eTable of Content\u003col\u003e\n\u003cli\u003eUpgrading and Setting up PostgreSQL 17\u003c\/li\u003e\n\u003cli\u003eExpert Database Cluster Administration\u003c\/li\u003e\n\u003cli\u003eAdvanced Database and Role Management\u003c\/li\u003e\n\u003cli\u003eConfiguration and Performance Tuning\u003c\/li\u003e\n\u003cli\u003eEffective Data Management\u003c\/li\u003e\n\u003cli\u003eTable Partitioning Strategies\u003c\/li\u003e\n\u003cli\u003eBackup and Recovery Best Practices\u003c\/li\u003e\n\u003cli\u003eStreaming Replication and High Availability\u003c\/li\u003e\n\u003cli\u003ePoint-in-Time Recovery\u003c\/li\u003e\n\u003c\/ol\u003e\u003cp\u003e\u003cbr\u003e\u003c\/p\u003e","brand":"GitforGits","offers":[{"title":"Default Title","offer_id":46639844163825,"sku":"9788119177523","price":39.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0674\/5433\/7265\/files\/9788119177523_p0.jpg?v=1771234774","url":"https:\/\/shop.barnesandnoble.com\/products\/9788119177523","provider":"Barnes \u0026 Noble","version":"1.0","type":"link"}