Packt+ | Advance your knowledge in tech

0

All Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Free Learning

PostgreSQL High Performance Cookbook

You're reading from PostgreSQL High Performance Cookbook Mastering query optimization, database monitoring, and performance-tuning for PostgreSQL

Product type Paperback

Published in Mar 2017

Publisher Packt

ISBN-13 9781785284335

Length 360 pages

Edition 1st Edition

Languages

SQL

Tools

PostgreSQL

Concepts

High Performance Programming

Authors (2):

Dinesh Kumar

Chitij Chauhan

View More author details

Table of Contents (19) Chapters

PostgreSQL High Performance Cookbook

Credits

About the Authors

About the Reviewers

www.PacktPub.com

Customer Feedback

Preface

1. Database Benchmarking FREE CHAPTER

2. Server Configuration and Control

3. Device Optimization

4. Monitoring Server Performance

5. Connection Pooling and Database Partitioning

6. High Availability and Replication

7. Working with Third-Party Replication Management Utilities

8. Database Monitoring and Performance

9. Vacuum Internals

10. Data Migration from Other Databases to PostgreSQL and Upgrading the PostgreSQL Cluster

11. Query Optimization

12. Database Indexing

Chapter 11. Query Optimization

In this chapter, we will cover the following recipes:

Using sample data sets
Timing overhead
Studying hot and cold cache behavior
Clearing the cache
Querying plan node structure
Generating an explain plan
Computing basic costs
Running sequential scans
Running bitmap heap and index scans
Aggregate and hash aggregate
Grouping
Working with set operations
Running a CTE scan
Nesting loops
Working with merge and hash join
Working on semi and anti joins

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 (2)

Chauhan

Chauhan

Chitij Chauhan currently works as a senior database administrator at an IT-based MNC in Chandigarh. He has over 10 years of work experience in the field of database and system administration, with specialization in MySQL clustering, PostgreSQL, Greenplum, Informix DB2, SQL Server 2008, Sybase, and Oracle. He is a leading expert in the area of database security, with expertise in database security products such as IBM InfoSphere Guardium, Oracle Database Vault, and Imperva.

See other products by Chauhan

Dinesh Kumar

Dinesh Kumar

Dinesh Kumar is an enthusiastic open source developer and has written several open source tools for PostgreSQL. He recently announced pgBucket, a brand new job scheduler for PostgreSQL. He is also a frequent blogger at manojadinesh.blogpsot.com, where he talks more about PostgreSQL. He is currently working as a senior database engineer in OpenSCG and building the PostgreSQL cloud operations. He has more than 6 years of experience as an Oracle and PostgreSQL database administrator and developer, and is currently focusing on PostgreSQL.

See other products by Dinesh Kumar

Other recommended products

Related to this chapter

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

PostgreSQL 10 High Performance

PostgreSQL 10 High Performance

PostgreSQL is increasingly utilized in all kind of applications, starting from desktop to web and mobile applications. In this book, you will find the best ways to design, monitor and maintain your PostgreSQL solution, with suggestions and tips for high performance, troubleshooting and high availability.

Apr 2018 16h 56m

PostgreSQL High Availability Cookbook

PostgreSQL High Availability Cookbook

Feb 2017 17h 52m

PostgreSQL 9.6 High Performance

PostgreSQL 9.6 High Performance

PostgreSQL is one of the most popular and widely adopted open source databases today. This book will show you how you can tackle the challenges faced while optimizing your database's performance using PostgreSQL 9.6. From optimizing your query performance to implementing the scaling and making your database highly available, this book covers all the essential performance optimization techniques you need to know.

May 2017 16h 56m

PostgreSQL 12 High Availability Cookbook

PostgreSQL 12 High Availability Cookbook

Database outages are costly and largely avoidable. That's why it's important to apply time-tested high availability techniques. This book will help you design and build an indestructible PostgreSQL 12 cluster that can remain online even in the direst circumstances. You will learn to monitor and automate your way to reassuring high availability.

Feb 2020 24h 28m

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

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

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

Mastering PostgreSQL 13

Mastering PostgreSQL 13

Updated to include the new features introduced in PostgreSQL 13, this book shows you how to build better PostgreSQL applications and administer your PostgreSQL database efficiently. You'll master the advanced features of PostgreSQL and develop the skills you need to build secure and highly available database solutions.

Nov 2020 15h 52m

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

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

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

Personalised recommendations for you

Based on your interests and search pattern

System Programming Essentials with Go

System Programming Essentials with Go

From file operations to process management and network programming, this hands-on guide equips software engineers with the skills to build efficient, reliable applications and optimize their performance.

Jun 2024 13h 36m

Technical Program Manager's Handbook

Technical Program Manager's Handbook

Unlock the full potential of your career as a TPM with this comprehensive guide, featuring new chapters on AI and more. Learn advanced techniques and gain insights from industry leaders. Elevate your skills and thrive in the Big Five tech companies.

Sep 2024 12h 16m

Systems Programming with C# and .NET

Systems Programming with C# and .NET

Unlock the full potential of C# and .NET Core in systems programming to secure, deploy, and maintain robust applications. With this book, you'll focus on low-level APIs, memory management, and performance optimization.

Jul 2024 15h 48m

System Design Guide for Software Professionals

System Design Guide for Software Professionals

This guide offers in-depth explanations of essential system design concepts, real-world case studies, and expert advice on acing tech interviews. Gain the knowledge to design scalable, high-performance systems and succeed in your career.

Aug 2024 12h 48m

Spring Boot 3.0 Cookbook

Spring Boot 3.0 Cookbook

Spring Boot 3.0 Cookbook demonstrates the latest features of this popular framework. You'll learn how to apply them to overcome challenges when building modern cloud applications.

Jul 2024 14h 12m

Refactoring with C++

Refactoring with C++

This book covers the most important software development techniques, libraries, and utilities unique to C++ that every C++ developer can use to refactor their code base. This will simplify development, enabling you to create performant apps.

Jul 2024 12h 16m

Microsoft Power Pages in Action

Microsoft Power Pages in Action

Packed with real-world examples, low-code coding techniques, and insights into crafting responsive pages, automating apps, and enhancing virtual agents, Microsoft Power Pages in Action is a valuable resource for building feature-rich web apps.

Jun 2024 11h 40m

This book will show you how to efficiently build applications using Vim's extensibility. You'll learn everything from advanced movement, text operations, and IDE features to refactoring, debugging, and customizing with Vimscript.

Jul 2024 10h 0m

Functional Programming with C#

Functional Programming with C#

This is a step-by-step guide to using existing C# tools to enhance programs with functional programming. It focuses on practical application with necessary theory and contains the latest C#12 examples and self-assessment questions.

Jul 2024 8h 36m

Edge Computing Simplified

Edge Computing Simplified

This book offers a holistic view of edge computing and the IoT space, helping you develop a foundational set of skills and learn terminologies to explore the subject in greater depth.

Jun 2024 5h 56m