There are several aspects to tuning the performance of PostgreSQL. These aspects are related to hardware configuration, network settings, and PostgreSQL configuration. PostgreSQL is often shipped with a configuration that is not suitable for production. Due to this, one should at least configure the PostgreSQL buffer settings, RAM settings, number of connections, and logging. Note that several PostgreSQL settings are correlated, such as the RAM settings and the number of connections. In addition to this, one should take great care with settings that require a server restart, because these are difficult to change in the production environment. Often, PostgreSQL produces a good execution plan if the physical structure of a database is normalized and the query is written properly. However, this is not always the case. To overcome performance issues, PostgreSQL provides the EXPLAIN utility command, which can be used to generate execution plans. The EXPLAIN command has several options...
Learning PostgreSQL 10 - Second Edition
Learning PostgreSQL 10 - Second Edition
Overview of this book
PostgreSQL is one of the most popular open source databases in the world, supporting the most advanced features included in SQL standards. This book will familiarize you with the latest features released in PostgreSQL 10.
We’ll start with a thorough introduction to PostgreSQL and the new features introduced in PostgreSQL 10. We’ll cover the Data Definition Language (DDL) with an emphasis on PostgreSQL, and the common DDL commands supported by ANSI SQL. You’ll learn to create tables, define integrity constraints, build indexes, and set up views and other schema objects. Moving on, we’ll cover the concepts of Data Manipulation Language (DML) and PostgreSQL server-side programming capabilities using PL/pgSQL. We’ll also explore the NoSQL capabilities of PostgreSQL and connect to your PostgreSQL database to manipulate data objects.
By the end of this book, you’ll have a thorough understanding of the basics of PostgreSQL 10 and will have the necessary skills to build efficient database solutions.
Related Content you might be interested in
Current Title:
Learning PostgreSQL 10 - Second Edition
Table of Contents (23 chapters)
Title Page
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Customer Feedback
Preface
Free Chapter
Relational Databases
PostgreSQL in Action
PostgreSQL Basic Building Blocks
PostgreSQL Advanced Building Blocks
SQL Language
Advanced Query Writing
Server-Side Programming with PL/pgSQL
OLAP and Data Warehousing
Beyond Conventional Data Types
Transactions and Concurrency Control
PostgreSQL Security
The PostgreSQL Catalog
Optimizing Database Performance
Using PostgreSQL in Python Applications
Customer Reviews