Packt+ | Advance your knowledge in tech

0

All Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Free Learning

PostgreSQL 10 High Performance

You're reading from PostgreSQL 10 High Performance Expert techniques for query optimization, high availability, and efficient database maintenance

Product type Paperback

Published in Apr 2018

Publisher Packt

ISBN-13 9781788474481

Length 508 pages

Edition 3rd Edition

Languages

SQL

Tools

PostgreSQL

Concepts

High Performance Programming

Author (1):

Enrico Pirozzi

View More author details

Table of Contents (23) Chapters

Title Page

Dedication

Packt Upsell

Contributors

Preface

1. PostgreSQL Versions FREE CHAPTER

2. Database Hardware

3. Database Hardware Benchmarking

4. Disk Setup

5. Memory for Database Caching

6. Server Configuration Tuning

7. Routine Maintenance

8. Database Benchmarking

9. Database Indexing

10. Query Optimization

11. Database Activity and Statistics

12. Monitoring and Trending

13. Pooling and Caching

14. Scaling with Replication

15. Partitioning Data

16. Avoiding Common Problems

1. Other Books You May Enjoy

Leave a review - let other readers know what you think

Index

Logical replication

One of the new features of PostgreSQL 10 is logical replication.

Logical replication is a method of replicating data objects and their changes, based upon their replication identity (usually a primary key). We use the term logical in contrast to physical replication, which uses exact block addresses and byte-by-byte replication. PostgreSQL supports both mechanisms concurrently.

Logical replication uses a publish and subscribe model with one or more subscribers subscribing to one or more publications on a publisher node. Subscribers pull data from the publications they subscribe to and may subsequently re-publish data to allow cascading replication or more complex configurations.

The concept is quite simple, a publication is created on the database master and a subscription is created on the slaves.

On the master (Node 1), we have to perform the following steps:

Set wal_level to logical on postgresql.conf
Create the role REPLICATION
Give the right permissions to the tables that...

The rest of the chapter is locked

Register for a free Packt account to unlock a world of extra content!

A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.

Unlock this book and the full library FREE for 7 days

Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of

Start free trial

Renews at $15.99/month. Cancel anytime

Authors (1)

Enrico Pirozzi

Enrico Pirozzi

Enrico Pirozzi, EnterpriseDB certified on implementation management and tuning, with a master's in computer science, has been a PostgreSQL DBA since 2003. Based in Italy, he has been providing database advice to clients in industries such as manufacturing and web development for 10 years. He has been training others on PostgreSQL since 2008. Dedicated to open source technology since early in his career, he is a cofounder of the PostgreSQL Italian mailing list, PostgreSQL-it, and of the PostgreSQL Italian community site, PSQL

See other products by Enrico Pirozzi

Other recommended products

Related to this chapter

PostgreSQL High Performance Cookbook

PostgreSQL High Performance Cookbook

This book will guide you to enhance your database's performance and give you insights into measuring and optimizing a PostgreSQL database to achieve better performance. You will be a able to perform various essential database tasks such as bench marking the database and optimizing the server's memory usage. This book will also help you to explore various memory optimization techniques offered by PostgreSQL.

Mar 2017 12h 0m

Developing Modern Database Applications with PostgreSQL

Developing Modern Database Applications with PostgreSQL

This book is divided into two parts with the first helping you to build advanced and scalable PostgreSQL apps. The second part enables you to administer them using DevOps. All the projects in this book will be demonstrated via the use of a small banking application for managing ATM machine locations in a typical city.

Aug 2021 14h 40m

PostgreSQL 13 Cookbook

PostgreSQL 13 Cookbook

PostgreSQL has become the most advanced open source database on the market. This book adopts a step-by-step approach to meet almost every requirement you can think of while deploying PostgreSQL in production environments. You will not only learn how to design and manage your database but also discover how to administer and secure the database.

Feb 2021 11h 28m

Learn PostgreSQL

Learn PostgreSQL

This book will get you up and running with the working of relational databases, data modeling, data manipulation, and more. You will learn to build efficient relational database solutions from scratch using the latest features of PostgreSQL 12 and 13. You'll also be able to identify bottlenecks to enhance the performance of database applications.

Oct 2020 21h 40m

Learning PostgreSQL 10

Learning PostgreSQL 10

This book will familiarize you with the latest new features released in PostgreSQL 10, and get you up and running with building efficient PostgreSQL database solutions from scratch. You will get a complete overview of SQL, client and server side programming in PostgreSQL, as well as some important administration tasks.

Dec 2017 16h 16m

PostgreSQL Administration Cookbook

PostgreSQL Administration Cookbook

PostgreSQL is a powerful, open source, object-relational database system, fast becoming one of the world's most popular server databases with an enviable reputation for performance and stability and an enormous range of advanced features. This is a practical guide aimed at giving sysadmins and database administrators the necessary toolkit to be able to set up, run, and extend powerful databases with PostgreSQL.

Apr 2017 18h 32m

Learning PostgreSQL 11

Learning PostgreSQL 11

This book will get you up and running with building efficient relational database solutions right from scratch with the newest features of PostgreSQL 11. You will learn the end-to-end working of relational databases and how to work with database structures. You will also be able to write essential SQL statements, perform data manipulation and do more, with the help of this book.

Jan 2019 18h 32m

PostgreSQL 11 Administration Cookbook

PostgreSQL 11 Administration Cookbook

PostgreSQL is a powerful open source database management system, now recognized as the experts' choice for a wide range of applications. This book contains useful administration recipes for improving the performance, security, and stability of your PostgreSQL 11 solution.

May 2019 20h 0m

Mastering PostgreSQL 9.6

Mastering PostgreSQL 9.6

PostgreSQL is an open source database management tool used for handling large datasets (big data) and as a JSON document database. It also has applications in the software and web domains. This book will enable you to build better PostgreSQL applications and administer databases more efficiently.

May 2017 13h 52m

Mastering PostgreSQL 11

Mastering PostgreSQL 11

This book includes the newly introduced features in PostgreSQL 11, and shows you how to build better PostgreSQL applications, and administer your PostgreSQL database efficiently. You will master the advanced features of PostgreSQL and acquire the necessary skills to build efficient database solutions.

Oct 2018 14h 52m

PostgreSQL 10 Administration Cookbook

PostgreSQL 10 Administration Cookbook

PostgreSQL is a powerful open source database management system, now recognized as the experts' choice for a wide range of applications. This book contains useful administration recipes for improving the performance, security, and stability of your PostgreSQL solution.

May 2018 19h 12m

Mastering PostgreSQL 10

Mastering PostgreSQL 10

PostgreSQL is an open source database used for handling large datasets (big data) and as a JSON document database. This book highlights the newly introduced features in PostgreSQL 10, and shows you how you can build better PostgreSQL applications, and administer your PostgreSQL database more efficiently.

Jan 2018 14h 16m

Personalised recommendations for you

Based on your interests and search pattern

LLVM Code Generation

LLVM Code Generation

LLVM is a key technology for building modern compilers. You'll learn how to use its infrastructure to create and extend backends (X86 and AArch64), and contribute to the LLVM open-source project, equipping you with key skills in compiler design.

May 2025 20h 40m

Domain-Driven Refactoring

Domain-Driven Refactoring

This book is your exhaustive guide to applying DDD practices for building robust applications. You'll learn key patterns, refine business logic, and solve real-world problems with DDD principles, refactoring, and event-driven architectures.

May 2025 10h 48m

The Power Platform Playbook for Digital Transformation

The Power Platform Playbook for Digital Transformation

Transform your business with Power Apps, Power Automate, Power BI, and Copilot Studio. This guide covers automation, AI insights, governance, and security, helping leaders, IT pros, and analysts build scalable, low-code enterprise solutions.

Apr 2025 11h 44m

Microservices with Go

Microservices with Go

The book covers Go microservice development, covering the basics for beginners and best practices for structuring Go apps. Novice as well seasoned developers will gain insights into managing and scaling microservices.

Jun 2025 14h 16m