Mastering PostgreSQL 17 - Elevate your database skills with advanced deployment optimization and security strategies

Hans-Jürgen Schönig

Summary

Starting with new features introduced in PostgreSQL 17, the sixth edition of this book provides comprehensive insights into advanced database management, helping you elevate your PostgreSQL skills to an expert level. Written by Hans-Jürgen Schönig, a PostgreSQL expert with over 25 years of experience and the CEO of CYBERTEC PostgreSQL International GmbH, this guide distills real-world expertise from supporting countless global customers. It guides you through crucial aspects of professional database management, including performance tuning, replication, indexing, and security strategies.
You’ll learn how to handle complex queries, optimize execution plans, and enhance user interactions with advanced SQL features such as window functions and JSON support. Hans equips you with practical approaches for managing database locks, transactions, and stored procedures to ensure peak performance. With real-world examples and expert solutions, you'll also explore replication techniques for high availability, along with troubleshooting methods to detect and resolve bottlenecks, preparing you to tackle everyday challenges in database administration.
By the end of the book, you'll be ready to deploy, secure, and maintain PostgreSQL databases efficiently in production environments.

Available since: 12/27/2024.

Print length: 474 pages.

Science & Technology

Other books that might interest you

How to become an airplane pilot

07

This audiobook is narrated by an AI Voice.  
Every person yearns to become a professional figure as he grows up. As children, we dream of being different figures, police officers, firefighters, soldiers, driving ships, planes, large trucks, and all kinds of jobs that take us to adventure. That is precisely what we are looking for, the adventure of living experiences. 
Being an airplane pilot is one of the main dreams that often surround children, dreams that perhaps, with the course of childhood, are transformed into different professions, or perhaps a dream that pursues us until adolescence, where we already at a higher degree of professional consciousness we decided to become airplane pilots. 
In this wonderful work, I will teach you everything you need to learn to become an airplane pilot, without taking "false steps", walking the right path, and doing everything you need to do to achieve it. 
It is not an aeronautical technical book, but a guide that will help you discover your career, navigate it, and know the right way to become a successful professional pilot.

Show book

AI Unleashed - Master Advanced...

Joe Ilunjo

Unlock the Future of AI—Beyond the Basics 
🚀 The Ultimate Guide to Advanced AI Mastery 
Sequel to the Bestseller "AI Simplified" 
You’ve automated tasks and dabbled with ChatGPT. Now, lead the AI revolution with AI Unleashed—the definitive playbook for entrepreneurs, developers, and visionaries ready to harness AI’s full power. 
Inside This Book, You’ll Learn How To:Build Self-Funding AI Agents that generate art, code, and even revenue streams (NFTs + blockchain).Land $50k+ Enterprise Contracts with compliance-ready AI solutions for Fortune 500s.Jailbreak & Fortify Models like GPT-4, ensuring they’re both powerful and ethical.Co-Create Inventions with AI and patent them in a legal gray zone.Prepare for AGI with governance frameworks and career strategies for 2030 and beyond. 
Why This Book Stands Out:No Fluff, Only Frontier Tech: Autonomous AI, decentralized models, AGI ethics.Ready-to-Deploy Templates: Enterprise contracts, AGI policies, red teaming checklists.Free Bonuses: Downloadable toolkit with 500+ advanced prompts and self-improving AI code. 
Click Add to Cart and transition from AI user to AI pioneer. The future won’t wait—unleash it. 
(Thank you for choosing my audiobook. If you have any questions, feedback, or if you’d like to request a digital or paperback copy of the book, please feel free to reach out to me at joenduga@gmail.com.)

Show book

Sleep Sounds 1 Fall Asleep...

Walkercrest

Welcome to a night of Deep Refreshing Sleep. 
The Audiobook gives you a bundle of two 12 hour programs. 
The programs begin after a short narration of guided imagery to prepare you for sleep. 
Program One: 12 hours of the sounds of Calming Rain, Distant Thunder and the Gentle Tones of Classical Music. 
Program Two: 10 hours of just the sounds of Calming Rain and Distant Thunder without the classical music. 
The classical musical tones are serene arrangements of the most-loved, composers: Bach, Beethoven, Chopin, Debussy, Mozart, Pachelbel, Rachmaninoff, Tchaikovsky and more. 
The producer of the audiobook is an award-winning sound designer and composer. When he and his wife struggled with sleep apnea, he searched for an audio program that would help. "I mostly found cheap sound effects with repetitive, looping tones. Granted, my background makes me a little picky, but I found these programs more annoying than relaxing." 
So he set out to record the best sounds he could find. The ocean waves, rain, thunder, streams and waterfalls are all original recordings. 
Next, he experimented with tones. This program is the first to include mellow arrangements of beautiful classical music. "I have produced over twenty experimental programs now and have had sleep doctors, patients, as well as my own friends and family members try them on. This current series of "Sleep Sounds" has been very well received and has been proven to be the most effective by the largest number of people."

Show book

Make Your Family Scam-Proof -...

Bryan Banks

This audiobook is narrated by an AI Voice. Scams do not look fake anymore. They sound like family emergencies, bank warnings, romance, threats, fake videos, urgent emails, and private disasters that make normal people panic before they can think. 
 
Make Your Family Scam-Proof gives families a practical routine for the first dangerous minutes of a scam. Bryan Banks shows listeners how to slow down pressure, verify frightening messages, protect money, respond to blackmail, help older parents, prepare teenagers, and make sure nobody faces fear alone. 
 
This audiobook is for parents, partners, adult children, grandparents, and households who want a simple, usable defence against modern fraud.

Show book

Build and Sell AI Chatbots - The...

Erica Thompson

This audiobook is narrated by an AI Voice.
The AI Gold Rush is Here. Most People Are Missing It. You Don't Have To.
Right now, thousands of businesses are desperately searching for someone to build AI chatbots that capture leads, book appointments, and handle customer service 24/7. The demand is exploding, but qualified providers are scarce. This is your opportunity to claim your share of the $183 billion AI chatbot market.
Build and Sell AI Chatbots reveals the complete blueprint for launching a profitable AI automation agency without writing a single line of code. Author Eric Thompson, a Senior ML Engineer who transitioned from oil field operations to building enterprise AI systems, strips away the complexity and shows you exactly how to build a recurring revenue business that generates $5,000 to $50,000 per month.
What You'll Master:
The No-Code Revolution: Build professional chatbots using platforms like Chatbase, Botpress, Voiceflow, and GoHighLevel without any technical background. Create client-ready solutions in hours, not weeks, using proven templates and workflows.
Profitable Niche Domination: Discover why targeting "boring businesses" like dental practices, home services companies, real estate agencies, and auto repair shops generates higher profits than chasing tech-savvy clients. Learn the 8 most lucrative industries that pay $500 to $2,000 monthly retainers without hesitation.
The White-Label Secret: Transform third-party platforms into your own branded AI solutions using GoHighLevel and other white-label systems. Present yourself as the technology provider, not just a service provider, commanding premium pricing with 70-90% profit margins.
Client Acquisition Systems: Master the "Demo Chatbot" technique that converts skeptical business owners into paying clients by showing immediate value. Learn LinkedIn outreach, local business targeting, and referral systems that make client acquisition predictable and scalable.
And more.

Show book

look Smart Listen Smart - A...

Jonathan Miller

Look Smart, Listen Smart: A Listener’s Guide to Stephen Hawking’s A Brief History of Time is a clear, confidence-building companion to one of the most famous — and most challenging — popular science books ever written. 
Stephen Hawking’s classic asks some of the biggest questions imaginable: Did the universe have a beginning? What is time? Why do black holes matter? Can physics explain the whole of reality? This guide helps listeners understand the structure, ideas, and importance of Hawking’s book before committing to the full work. 
Written for curious non-specialists, it explains relativity, quantum mechanics, black holes, the expanding universe, the arrow of time, wormholes, and the search for a unified theory in plain, intelligent language. It is not a substitute for Hawking’s original, but a serious orientation to it — showing what each chapter does, why the ideas matter, and whether the book is likely to suit you. 
Ideal for audiobook listeners, students, science lovers, and thoughtful readers who want to approach difficult books with more confidence, Look Smart, Listen Smart helps you listen deeper, understand faster, and get more from a landmark work of modern science.

Show book