PostgreSQL 9.6 High Performance

More Information
Learn
  • Learn the best practices to configure your PostgreSQL 9.6 database for optimal performance
  • Write optimal queries and techniques to detect performance issue in queries
  • Fine tune the performance of your queries using benchmarking and indexing techniques
  • Ensure high performance and a highly available database using the scaling and replication techniques
  • Discover how to make informed speed and reliability trade-offs
  • Handle increasing database workloads without any hassle
  • Use monitoring insights to continuously rework the design and configuration for best performance
About

Database administrators and developers spend years learning techniques to configure their PostgreSQL database servers for optimal performance, mostly when they encounter performance issues. Scalability and high availability of the database solution is equally important these days. This book will show you how to configure new database installations and optimize existing database server installations using PostgreSQL 9.6.

You will start with the basic concepts of database performance, because all successful database applications are destined to eventually run into issues when scaling up their performance. You will not only learn to optimize your database and queries for optimal performance, but also detect the real performance bottlenecks using PostgreSQL tools and some external tools. Next, you will learn how to benchmark your hardware and tune your operating system. Optimize your queries against the database with the help of right indexes, and monitor every layer, ranging from hardware to queries. Moving on, you will see how connection pooling, caching, partitioning, and replication will help you handle increasing database workloads.

Achieving high database performance is not easy, but you can learn it by using the right guide—PostgreSQL 9.6 High Performance.

Features
  • Learn the right techniques to obtain optimal PostgreSQL database performance, ranging from initial design to routine maintenance
  • Fine tune the performance of your queries and avoid the common pitfalls that can slow your system down
  • Contains tips and tricks on scaling successful database installations, and ensuring a highly available PostgreSQL solution
Page Count 508
Course Length 15 hours 14 minutes
ISBN 9781784392970
Date Of Publication 30 May 2017

Authors

Gregory Smith

Gregory Smith is a chief PostgreSQL evangelist in Charleston, South Carolina, for Crunchy Data Solutions. He's been providing database advice to clients in industries such as manufacturing, finance, and web development for 20 years. He has contributed feature additions to every PostgreSQL version since 8.3. He's also the creator of a growing set of add-on tools for the database, currently including PgTune, pgbench-tools, peg, and 2warm.

Ibrar Ahmed

Ibrar Ahmed is a senior database architect in an Enterprise PostgreSQL company. He started his development career in 1999. He has contributed to the PostgreSQL community, the company's PostgreSQL fork, and other open source communities such as Google Chrome. He also has experience in MySQL, Oracle, MongoDB and Hadoop (Hive, Hbase, Spark). He is a major contributor in integrating other databases with PostgreSQL. He also authored PostgreSQL Developer's Guide. He has a master's in computer science (1999) and MS in computer engineering (2015), and is finalizing his PhD.