PostgreSQL High Performance Cookbook

This is the code repository for PostgreSQL High Performance Cookbook, published by Packt. It contains all the supporting project files necessary to work through the book from start to finish.

About the Book

PostgreSQL is one of the most powerful and easy to use database management systems. It has strong support from the community and is being actively developed with a new release every year. PostgreSQL supports the most advanced features included in SQL standards. It also provides NoSQL capabilities and very rich data types and extensions. All of this makes PostgreSQL a very attractive solution in software systems.

If you run a database, you want it to perform well and you want to be able to secure it. As the world’s most advanced open source database, PostgreSQL has unique built-in ways to achieve these goals. This book will show you a multitude of ways to enhance your database’s performance and give you insights into measuring and optimizing a PostgreSQL database to achieve better performance.

Instructions and Navigation

All of the code is organized into folders. Each folder starts with a number followed by the application name. For example, Chapter02.

The code will look like the following:

$ phoronix-test-suite benchmark pts/himeno
Phoronix Test Suite v6.8.0
 To Install: pts/himeno-1.2.0
 ...
 1 Test To Install
 pts/himeno-1.2.0:
 Test Installation 1 of 1
 1 File Needed
 Downloading: himenobmtxpa.tar.bz2
 Started Run 2 @ 05:53:40
 Started Run 3 @ 05:54:35 [Std. Dev: 1.66%]
Test Results:
 1503.636072
 1512.166077
 1550.985494
Average: 1522.26 MFLOPS

In general, a modern Unix-compatible platform should be able to run PostgreSQL. To make the most out of this book, you also require CentOS 7. The minimum hardware required to install and run PostgreSQL is as follows: 1 GHz processor 1 GB of RAM 512 MB of HDD

packtpublishing / postgresql-high-performance-cookbook Goto Github PK