Join us on a literary world trip!
Add this book to bookshelf
Grey
Write a new comment Default profile 50px
Grey
Subscribe to read the full book or read the first pages for free!
All characters reduced
PostgreSQL 16 Administration Cookbook - Solve real-world Database Administration challenges with 180+ practical recipes and best practices - cover

PostgreSQL 16 Administration Cookbook - Solve real-world Database Administration challenges with 180+ practical recipes and best practices

Simon Riggs, Gianni Ciolli, Boriss Mejías, Jimmy Angelakos, Vibhor Kumar

Publisher: Packt Publishing

  • 0
  • 0
  • 0

Summary

PostgreSQL has seen a huge increase in its customer base in the past few years and is becoming one of the go-to solutions for anyone who has a database-specific challenge. This PostgreSQL book touches on all the fundamentals of Database Administration in a problem-solution format. It is intended to be the perfect desk reference guide.This new edition focuses on recipes based on the new PostgreSQL 16 release. The additions include handling complex batch loading scenarios with the SQL MERGE statement, security improvements, running Postgres on Kubernetes or with TPA and Ansible, and more. This edition also focuses on certain performance gains, such as query optimization, and the acceleration of specific operations, such as sort. It will help you understand roles, ensuring high availability, concurrency, and replication. It also draws your attention to aspects like validating backups, recovery, monitoring, and scaling aspects. This book will act as a one-stop solution to all your real-world database administration challenges.By the end of this book, you will be able to manage, monitor, and replicate your PostgreSQL 16 database for efficient administration and maintenance with the best practices from experts.
Available since: 12/04/2023.
Print length: 636 pages.

Other books that might interest you

  • The UFO Experience - Evidence Behind Close Encounters Project Blue Book and the Search for Answers - cover

    The UFO Experience - Evidence...

    J. Allen Hynek

    • 1
    • 1
    • 0
    Cited by the New York Review of Books as “the best brief for visitation,” this classic study presents an analysis of UFO reports and concludes that many sightings cannot be easily dismissed.The case against UFOs and unidentified aerial phenomena (UAP) has not been put to rest. Although UFOs “officially” did not exist for decades according to the government, reports of sightings continue to be made, and the latest releases from the government and related hearings have surprised the world. While the scientific community has put UFOs out to pasture, the evidence used to dismiss them is rare and unscientific.Dr. Hynek, a scientist himself, and the only government-paid ufologist in history, looks at the decisions made by officialdom in the early days of ufology and how these decisions have held us back—to the point that we are still naively talking about UFOs as we were in the 1950s. Has seventy years of research made no difference at all in our understanding?Dr. Hynek proves that there is a conspiracy afoot to hide the facts and that there are many cases that still need to be explained by mainstream science—not dismissed with facile jokes and stupid logic. Citing specific cases, Hynek challenges those in the ivory tower by raising questions that have still not been answered and refuting mainstream arguments that have yet to be proven.
    Show book
  • Tracks - A Journey Through Metroland - cover

    Tracks - A Journey Through...

    Kevin J. Last

    • 0
    • 0
    • 0
    Tracks: A Journey Through Metroland tells the story of Metroland and the development of suburbia that grew alongside the Metropolitan Railway. Originally the brainchild of eminent Victorians, the Metropolitan grew to become the queen of underground lines, eventually expanding to a point some fifty miles outside London. Author Kevin J. Last describes how the concept of Metroland was an aspiration for several levels of society, promising a better lifestyle well away from the deprivations of wartime. The idea that the working man could live comfortably outside the smoke in individually designed houses would mean that he could also thrive at work, largely due to the regular service offered by the new railway. This was quite exceptional in that, while nominally an underground line, most of the Met's route was above ground and, in length, went far beyond other similar lines, far out into the Buckinghamshire countryside. Not marked on any map, Metroland is as much a concept of the mind as a real place.
    Show book
  • Dr Quantum Presents: Meet the Real Creator- You! - cover

    Dr Quantum Presents: Meet the...

    PhD Fred Alan Wolf

    • 0
    • 0
    • 0
    The more you learn about quantum physics, the more you wonder: Who is really creating your reality? Fear not: Dr. Quantum, superhero of spiritual science, is here to help you Meet the Real Creator—You! Join this champion of modern thought (sometimes known by his alter ego, Dr. Fred Alan Wolf) on a quest for truth through the strange reality of quantum physics.  
    Listeners will discover how we participate in the manifestation of each moment, why the universe only seems to be beyond our ability to control, and how we can use the principles of cutting-edge science to truly take charge of our lives. On this four-part journey into understanding, Dr. Quantum will unravel such mysteries as:Your "spiritual elephant"—who is really in control of your life from a quantum perspective? Quantum heaven, quantum hell—if we create our own reality, why do things happen that we don't want?" If I have a soul, why doesn't it do something?" How to open a dialogue between your "self" and "soul" Is there one soul, or are there many? A quantum perspective on the nature of self and other 
    Whether he's rescuing listeners from confusion about subatomic subtleties or breaking down the barriers between science and spirit, Dr. Wolf sets the standard for bringing quantum physics down to earth—and into our lives.
    Show book
  • Cracking Top Tech Frontend Interviews - A complete guide to mastering frontend technologies for interviews: HTML CSS A11Y JS & React - cover

    Cracking Top Tech Frontend...

    DSA Shots

    • 0
    • 0
    • 0
    A Complete Guide to Frontend Interviews is your key to unlocking success in the competitive tech industry. Inside this comprehensive guide, you'll find: 
    * In-depth coverage of HTML, CSS, JS, and React, including best practices and common interview questions 
    * Expert tips and strategies for acing your frontend interviews, from resume review to salary negotiations 
    * Real-world examples and case studies to help you understand the concepts better 
    * Practice problems and exercises to test your knowledge and reinforce your understanding 
    Whether you're a seasoned developer or just starting out, this book is your ultimate resource for frontend interviews. With our expert guidance, you'll be well-prepared to tackle any interview question and land your dream job in tech. Get ready to take your skills to the next level and join the ranks of top tech professionals!
    Show book
  • Artificial Intelligence in Advertising - cover

    Artificial Intelligence in...

    Introbooks Team

    • 0
    • 0
    • 0
    Technology has changed the world. The technology is also constantly changing. Therefore, the changes that take place affect each and everything. Artificial intelligence can be regarded as the most revolutionary innovation in the technological world. This has changed the way the general public uses technology. Many industries have been affected by the advent of artificial intelligence. The advertising industry is one of them. The creation of ads, content generation, data collection, data analysis, tracking of consumer behavior, all these have been changed completely after the creation of artificial intelligence. The brands are able to track the correct consumer behaviors and personize the ads accordingly. The cost of ad creation has been reduced to a very low level.  
    The virtual assistance and streamlining of ads has opened up new avenues for advertisers to bid up their game. The consumers are also benefitted by the better algorithms that allow them to see relatable ads and eliminate the ones that eat up their time. 
    Show book
  • CRACK99 - The Takedown of a $100 Million Chinese Software Pirate - cover

    CRACK99 - The Takedown of a $100...

    David Locke Hall

    • 0
    • 0
    • 0
    The utterly gripping story of the most outrageous case of cyber piracy prosecuted by the US Department of Justice 
    A former US Navy intelligence officer, David Locke Hall was a federal prosecutor when a bizarre-sounding website, CRACK99, came to his attention. It looked like Craigslist on acid, but what it sold was anything but amateurish: thousands of high-tech software products used largely by the military, and for mere pennies on the dollar. Want to purchase satellite tracking software? No problem. Aerospace and aviation simulations? No problem. Communications systems designs? No problem. Software for Marine One, the presidential helicopter? No problem. With delivery times and customer service to rival the world’s most successful online retailers, anybody, anywhere―including rogue regimes, terrorists, and countries forbidden from doing business with the United States―had access to these goods for any purpose whatsoever. 
    But who was behind CRACK99, and where were they? The Justice Department discouraged potentially costly, risky cases like this, preferring the low-hanging fruit that scored points from politicians and the public. But Hall and his colleagues were determined to find the culprit. They bought CRACK99’s products for delivery in the United States, buying more and more to appeal to the budding entrepreneur in the man they identified as Xiang Li. After winning his confidence, they lured him to Saipan―a US commonwealth territory where Hall’s own father had stormed the beaches with the marines during World War II. There they set up an audacious sting that culminated in Xiang Li’s capture and imprisonment. The value of the goods offered by CRACK99? A cool $100 million. 
    An eye-opening look at cybercrime and its chilling consequences for national security, CRACK99 reads like a caper that resonates with every amazing detail.
    Show book