{"product_id":"postgresql-17-quickstart-pro-add-expertise-around-wal-processing-json-table-io-performance-logical-replication-and-index-vacuuming-9788119177844","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\u003eUpgrading and Setting up PostgreSQL 17Expert Database Cluster AdministrationAdvanced Database and Role ManagementConfiguration and Performance TuningEffective Data ManagementTable Partitioning StrategiesBackup and Recovery Best PracticesStreaming Replication and High AvailabilityPoint-in-Time Recovery\u003c\/ol\u003e\u003cp\u003e\u003cbr\u003e\u003c\/p\u003e\u003cbr\u003e\u003cbr\u003e\u003cb\u003eBinding Type:\u003c\/b\u003e Paperback\u003cbr\u003e\u003cb\u003ePublisher:\u003c\/b\u003e Gitforgits\u003cbr\u003e\u003cb\u003ePublished:\u003c\/b\u003e 10\/01\/2024\u003cbr\u003e\u003cb\u003eISBN:\u003c\/b\u003e 9788119177844\u003cbr\u003e\u003cb\u003ePages:\u003c\/b\u003e 184\u003cbr\u003e\u003cb\u003eWeight:\u003c\/b\u003e 0.72lbs\u003cbr\u003e\u003cb\u003eSize:\u003c\/b\u003e 9.25h x 7.50w x 0.39d","brand":"Tessa Vorin","offers":[{"title":"Default Title","offer_id":45396528726197,"sku":"9788119177844","price":59.49,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0473\/0804\/6492\/files\/img_9c6915a6-5ac9-48db-a0b3-d6ec0876b5b7.jpg?v=1747750204","url":"https:\/\/pastforward.org\/products\/postgresql-17-quickstart-pro-add-expertise-around-wal-processing-json-table-io-performance-logical-replication-and-index-vacuuming-9788119177844","provider":"Past Forward","version":"1.0","type":"link"}