Mastering PostgreSQL 15 - Fifth Edition: Advanced techniques to build and manage scalable, reliable, and fault-tolerant database applications

Name: Mastering PostgreSQL 15 - Fifth Edition: Advanced techniques to build and manage scalable, reliable, and fault-tolerant database applications
Brand: Atlantic Books
SKU: 9781803248349
Price: 6811.0 INR
Availability: InStock

by Hans-Jürgen Schönig

Save 5%

₹6,811.00

₹7,154.00

(-5%)

₹6,811.00

Imported Edition - Ships in 18-21 Days

Free Shipping in India on orders above Rs. 500

Request Bulk Quantity Quote

Name

Quantity

+91

Company Name

Message

Quantity

More Information

ISBN13: 9781803248349
Binding: Paperback
Subject: N/A
Publisher: Packt Publishing
Publisher Imprint: Packt Publishing
Publication Date: January 31, 2023
Pages: 522
Original Price: USD 72.99
Language: English
Edition: 5. Auflage
Item Weight: 889 grams
BISAC Subject(s): Buyer's Guides

About The Book

Master the capabilities of PostgreSQL 15 to efficiently administer and maintain your database.

Purchase of the print or Kindle book includes a free PDF eBook.

Key Features:

- Using real world examples, get to grips with expert PostgreSQL 15 concepts

- Explore performance improvement, database replication, data replication, database administration, and more

- Extend PostgreSQL's functionalities to suit your organization's needs with minimal effort

Book Description:

Starting with an introduction to the newly released features of PostgreSQL 15, this updated fifth edition will help you get to grips with PostgreSQL administration and how to build dynamic database solutions for enterprise apps, including designing both physical and technical aspects of the system.

You'll explore advanced PostgreSQL features, such as logical replication, database clusters, advanced indexing, and user management to manage and maintain your database. You'll then work with the PostgreSQL optimizer, configure PostgreSQL for high speed, and move from Oracle to PostgreSQL. Among the other skills that the book will help you build, you'll cover transactions, handling recursions, working with JSON and JSONB data, and setting up a Patroni cluster. It will show you how to improve performance with query optimization. You'll also focus on managing network security and work with backups and replication while exploring useful PostgreSQL extensions that optimize the performance of large databases.

By the end of this PostgreSQL book, you'll be able to use your database to its utmost capacity by implementing advanced administrative tasks with ease.

What You Will Learn:

- Make use of the indexing features in PostgreSQL and fine-tune the performance of your queries

- Work with stored procedures and manage backup and recovery

- Get the hang of replication and failover techniques

- Improve the security of your database server and handle encryption effectively

- Troubleshoot your PostgreSQL instance for solutions to common and not-so-common problems

- Perform database migration from Oracle to PostgreSQL with ease

Who this book is for:

This database administration book is for PostgreSQL developers, database administrators, and professionals who want to implement advanced functionalities and master complex administrative tasks with PostgreSQL 15. Prior experience in PostgreSQL and familiarity with the basics of database administration will assist with understanding key concepts covered in the book.

Table of Contents

- PostgreSQL 15 Overview

- Understanding Transactions and Locking

- Making Use of Indexes

- Handling Advanced SQL

- Log Files and System Statistics

- Optimizing Queries for Good Performance

- Writing Stored Procedures

- Managing PostgreSQL Security

- Handling Backup and Recovery

- Making Sense of Backups and Replication

- Deciding on Useful Extensions

- Troubleshooting PostgreSQL

- Migrating to PostgreSQL

About The Author

Schönig, Hans-Jürgen: - Hans-Jürgen Schönig has 25 years of experience with PostgreSQL. He is the CEO of a PostgreSQL consulting and support company called CYBERTEC PostgreSQL International GmbH, which has successfully served countless customers around the globe. Before founding CYBERTEC PostgreSQL International GmbH in 2000, he worked as a database developer at a private research company that focused on the Austrian labor market, where he primarily worked on data mining and forecast models. He has also written several books about PostgreSQL.

Trusted for over 49 years

Family Owned Company

Secure Payment

All Major Credit Cards/Debit Cards/UPI & More Accepted

New & Authentic Products

India's Largest Distributor

Need Support?

Whatsapp Us

Related Category

computers > buyer's guides

Bestselling

View All

Atomic Habits (Lead Title)

Clear, James

₹585

₹899

(-35%)

₹585

• Author(s): Clear | James • Publisher: Penguin • Publisher Imprint: Penguin Random House • Subject: General Books

Diary of a Wimpy Kid: Partypooper (Book 20)

Jeff Kinney

₹455

₹699

(-35%)

₹455

• Author(s): Jeff Kinney • Publisher: Penguin Random House Children's UK • Publisher Imprint: Penguin Random House Children's UK • BISAC: Comics & Graphic Novels - Humorous

Ikigai

Hector Garcia

₹390

₹599

(-35%)

₹390

• Author(s): Hector Garcia • Publisher: Penguin • Publisher Imprint: Penguin Random House • Subject: General Books

The Courage To Be Disliked How To Free Yourself Change Your Life And Achieve Real Happiness Courage To Series

Ichiro Kishimi

₹358

₹550

(-35%)

₹358

• Author(s): Ichiro Kishimi • Publisher: GROVE ATLANTIC • Publisher Imprint: Allen & Unwin • BISAC: Personal Growth - SuccessIchiro Kishimi lives in Kyoto. He writes, lectures and teaches in psychiatric clinics as a certified counsellor and c...

View full details

12 Years: My Messed-up Love Story

Chetan Bhagat

₹260

₹399

(-35%)

₹260

• Author(s): Chetan Bhagat • Publisher: HarperCollins Publishers India • Publisher Imprint: HarperCollins Publishers India • BISAC: GeneralFrom India's top-selling writer Chetan Bhagat comes a powerful new love story that will make you laugh, cry...

View full details

The Mountain Is You: Transforming Self-Sabotage Into Self-Mastery

Brianna Wiest

₹260

₹399

(-35%)

₹260

• Author(s): Brianna Wiest • Publisher: Manjul Publishing • Publisher Imprint: Amaryllis • BISAC: Body Mind And SpiritThis is a book about self-sabotage. Why we do it, when we do it, and how to stop doing it—for good. Coexisting but conflicting n...

View full details

The Art of Spending Money: Simple Choices for a Richer Life

Morgan Housel

₹290

₹499

(-42%)

₹290

• Author(s): Morgan Housel • Publisher: Pan Macmillan • Publisher Imprint: Pan Macmillan • BISAC: Finance - Wealth ManagementA third book from the International bestselling author of The Psychology of Money and Same as Ever, lessons on harnessing...

View full details

Mother Mary Comes To Me

Arundhati Roy

₹585

₹899

(-35%)

₹585

• Author(s): Arundhati Roy• Publisher: PRH INDIA LOCAL PRINT• Publisher Imprint: Penguin Hamish Hamilton• BISAC: Literary FiguresArundhati Roy’s first work of memoir, this is a soaring account, both intimate and inspiring, of how the author became...

View full details

Truth without Apology: A Guide for Those Who Can Stand It

Acharya Prashant

₹260

₹399

(-35%)

₹260

• Author(s): Acharya Prashant • Publisher: HarperCollins Publishers India • Publisher Imprint: HarperCollins Publishers India • BISAC: GeneralIn a world where vagueness is mistaken for depth and obscurity passes for wisdom, Truth without Apology ...

View full details

Grandma's Bag of Stories

Sudha Murthy

₹179

₹275

(-35%)

₹179

• Author(s): Sudha Murthy • Publisher: India Puffin • Publisher Imprint: India Puffin • BISAC: Short StoriesWho can resist a good story, especially when it's being told by Grandma? From her bag emerges tales of kings and cheats, monkeys and mic...

View full details

Days at the Morisaki Bookshop

Satoshi Yagisawa

₹260

₹399

(-35%)

₹260

• Author(s): Satoshi Yagisawa • Publisher: Bonnier Books Ltd • Publisher Imprint: Bonnier Books Ltd

Deep Work: Rules For Focused Success In A Distracted World

Newport, Cal

₹260

₹399

(-35%)

₹260

• Author(s): Newport, Cal • Publisher: Little, Brown Book Group • Publisher Imprint: Piatkus

Can We Be Strangers Again?: A National Bestseller

Shrijeet Shandilya

₹195

₹299

(-35%)

₹195

• Author(s): Shrijeet Shandilya • Publisher: Ebury Press • Publisher Imprint: Ebury Press • BISAC: Romance - GeneralIn the electric haze of college life, three friends are bound by laughter, late-night talks and unspoken promises. But when two of...

View full details

The Secret of Secrets: (Robert Langdon Book 6)

Dan Brown

₹975

₹1,499

(-35%)

₹975

• Author(s): Dan Brown • Publisher: Transworld Publishers Ltd • Publisher Imprint: Transworld Publishers Ltd • BISAC: Thrillers - EspionageDan Brown is the bestselling author of Digital Fortress, Deception Point, Angels and Demons, The Da Vinci C...

View full details

Magic of the Lost Temple

Sudha Murty

₹179

₹275

(-35%)

₹179

• Author(s): Sudha Murty • Publisher: India Puffin • Publisher Imprint: India Puffin • BISAC: Action & Adventure - General

Rich Dad Poor Dad: What the Rich Teach Their Kids about Money That the Poor and Middle Class Do Not!

₹390

₹599

(-35%)

₹390

• Publisher: Penguin • Publisher Imprint: Penguin Random House • Subject: General Books • BISAC: Personal Finance - GeneralApril of 2022 marks a 25-year milestone for the personal finance classic Rich Dad Poor Dad that still ranks as the #1 Pers...

View full details

World’S Greatest Books For Personal Growth & Wealth (Set Of 4 Books) : Perfect Motivational

Dale Carnegie, Napoleon Hill

₹390

₹599

(-35%)

₹390

• Author(s): Dale Carnegie | Napoleon Hill • Publisher: Fingerprint • Publisher Imprint: Fingerprint • Subject: General Books

The Housemaid: An Addictive Psychological Thriller With Mind-Bending Twists

Freida Mcfadden

₹358

₹550

(-35%)

₹358

• Author(s): Freida Mcfadden • Publisher: Penguin Select Print • Publisher Imprint: Penguin Select Publishing"Multi-Million Copy Bestselling Series •Now Being Made Into a Major Motion Picture Starring Sydney Sweeney and Amanda Seyfried #1 New Yor...

View full details

101 Tales: The Great Panchatantra Collection

Wonder House Books

₹390

₹599

(-35%)

₹390

• Author(s): Wonder House Books • Publisher: Wonder House Books • Publisher Imprint: Wonder House Books • BISAC: Comics & Graphic Novels - Fairy Tales, Folklore, Legends & MTimeless Wisdom, Talking Animals & Life Lessons for Young Min...

View full details

Man's Search For Meaning

Viktor E. Frankl

₹260

₹399

(-35%)

₹260

• Author(s): Viktor E. Frankl • Publisher: Random House • Publisher Imprint: Random Hou • Subject: Medical, Nursing and Health Sciences

Bacchon KI Doctor's Desi Parenting Book: A Doctor-Mom's Guide to Milk, Myths, Motherhood and More

Madhavi Bharadwaj

₹260

₹399

(-35%)

₹260

• Author(s): Madhavi Bharadwaj • Publisher: PRH India • Publisher Imprint: Penguin Ebury Press • BISAC: Parenting - MotherhoodWelcome to the wild, messy, wonderful world of parenting--where the nights are long, the diapers are explosive, and unso...

View full details

The Outsider

Vir Das

₹455

₹699

(-35%)

₹455

• Author(s): Vir Das • Publisher: HarperCollins Publishers India • Publisher Imprint: HarperCollins Publishers India • BISAC: Entertainment & Performing ArtsComedian and actor Vir Das is beloved (by some, tolerated by others, blocked by a few...

View full details

The Very Hungry Caterpillar

Eric Carle

₹293

₹450

(-35%)

₹293

• Author(s): Eric Carle • Publisher: Penguin Books, Limited (UK) • Publisher Imprint: Penguin Books, Limited (UK) • BISAC: Animals - Butterflies, Moths & CaterpillarsEric Carle's The Very Hungry Caterpillar is a perennial favourite with child...

View full details

Too Good to Be True : A smart, funny will-they-won’t-they romance by mostlysane

Prajakta Koli

₹260

₹399

(-35%)

₹260

• Author(s): Prajakta Koli • Publisher: Harper Fiction India • Publisher Imprint: Harper Fiction India • BISAC: Romance - ContemporaryWinner of the Amazon India Popular Choice Debut Book 2025 Award. From one of India's most-loved creators comes s...

View full details

Mastering PostgreSQL 15 - Fifth Edition: Advanced techniques to build and manage scalable, reliable, and fault-tolerant database applications

Related Category

Bestselling

Atomic Habits (Lead Title)

Diary of a Wimpy Kid: Partypooper (Book 20)

Ikigai

The Courage To Be Disliked How To Free Yourself Change Your Life And Achieve Real Happiness Courage To Series

12 Years: My Messed-up Love Story

The Mountain Is You: Transforming Self-Sabotage Into Self-Mastery

The Art of Spending Money: Simple Choices for a Richer Life

Mother Mary Comes To Me

Truth without Apology: A Guide for Those Who Can Stand It

Grandma's Bag of Stories

Days at the Morisaki Bookshop

Deep Work: Rules For Focused Success In A Distracted World

Can We Be Strangers Again?: A National Bestseller

The Secret of Secrets: (Robert Langdon Book 6)

Magic of the Lost Temple

Rich Dad Poor Dad: What the Rich Teach Their Kids about Money That the Poor and Middle Class Do Not!

World’S Greatest Books For Personal Growth & Wealth (Set Of 4 Books) : Perfect Motivational

The Housemaid: An Addictive Psychological Thriller With Mind-Bending Twists

101 Tales: The Great Panchatantra Collection

Man's Search For Meaning

Bacchon KI Doctor's Desi Parenting Book: A Doctor-Mom's Guide to Milk, Myths, Motherhood and More

The Outsider

The Very Hungry Caterpillar

Too Good to Be True : A smart, funny will-they-won’t-they romance by mostlysane

Customer Reviews

Added to your cart:

Mastering PostgreSQL 15 - Fifth Edition: Advanced techniques to build and manage scalable, reliable, and fault-tolerant database applications

Related Category

Bestselling

Customer Reviews

Country

Country