PostgreSQL 10 High Performance

Expert techniques for query optimization, high availability, and efficient database maintenance



Bookstore > Books > PostgreSQL 10 High Performance

Price$44.99 - $48.37
Rating
AuthorsIbrar Ahmed, Gregory Smith, Enrico Pirozzi
PublisherPackt Publishing
Published2018
Pages508
LanguageEnglish
FormatPaper book / ebook (PDF)
ISBN-101788474481
ISBN-139781788474481
EBook Hardcover Paperback

PostgreSQL database servers have a common set of problems that they encounter as their usage gets heavier and requirements get more demanding. Peek into the future of your PostgreSQL 10 database's problems today. Know the warning signs to look for and how to avoid the most common issues before they even happen.

Surprisingly, most PostgreSQL database applications evolve in the same way - choose the right hardware, tune the operating system and server memory use, optimize queries against the database and CPUs with the right indexes, and monitor every layer, from hardware to queries, using tools from inside and outside PostgreSQL. Also, using monitoring insight, PostgreSQL database applications continuously rework the design and configuration. On reaching the limits of a single server, they break things up; connection pooling, caching, partitioning, replication, and parallel queries can all help handle increasing database workloads.

By the end of this book, you will have all the knowledge you need to design, run, and manage your PostgreSQL solution while ensuring high performance and high availability.


  1. (3 books)
  2. (2 books)


4 5 7

Similar Books


PostgreSQL 10 Administration Cookbook

PostgreSQL 10 Administration Cookbook

by Simon Riggs, Gianni Ciolli

PostgreSQL is a powerful, open source database management system with an enviable reputation for high performance and stability. With many new features in its arsenal, PostgreSQL 10 allows users to scale up their PostgreSQL infrastructure. This book takes a step-by-step, recipe-based approach to effective PostgreSQL administration.Through...

Price:  $49.99  |  Publisher:  Packt Publishing  |  Release:  2018

Clojure High Performance Programming

Clojure High Performance Programming

by Shantanu Kumar

Clojure is a young, dynamic, functional programming language that runs on the Java Virtual Machine. It is built with performance, pragmatism, and simplicity in mind. Like most general purpose languages, Clojure's features have different performance characteristics that one should know in order to write high performance code.Clojure H...

Price:  $20.99  |  Publisher:  Packt Publishing  |  Release:  2013

High Performance Web Sites

High Performance Web Sites

by Steve Souders

Want to speed up your web site? This book presents 14 specific rules that will cut 20% to 25% off response time when users request a page. Author Steve Souders, in his job as Chief Performance Yahoo!, collected these best practices while optimizing some of the most-visited pages on the Web. Even sites that had already been highly optimize...

Price:  $4.30  |  Publisher:  O'Reilly Media  |  Release:  2007

Learn PostgreSQL

Learn PostgreSQL

by Luca Ferrari , Enrico Pirozzi

PostgreSQL is one of the fastest-growing open source object-relational database management systems (DBMS) in the world. As well as being easy to use, it's scalable and highly efficient. In this book, you'll explore PostgreSQL 12 and 13 and learn how to build database solutions using it. Complete with hands-on tutorials, this gui...

Price:  $44.99  |  Publisher:  Packt Publishing  |  Release:  2020

High-Performance Caching with Nginx and Nginx Plus

High-Performance Caching with Nginx and Nginx Plus

by Floyd Smith

You can cache static assets - more than half the payload needed to respond to many web requests - and even application?generated web pages (whether partial or complete). And you can use cache clusters and microcaching to increase the caching capability of your web applications while simplifying implementation and reducing operational comp...

Free ebook  |  Publisher:  Self-publishing  |  Release:  2017

NGINX High Performance

NGINX High Performance

by Rahul Sharma

NGINX is one of the most common free, open source web servers. Its performance-oriented architecture and small footprint makes it an ideal choice for high-traffic websites.NGINX offers great performance and optimal resource utilization to its administrators. This practical guide walks you through how to tune one of the leading free open s...

Price:  $29.99  |  Publisher:  Packt Publishing  |  Release:  2015

High-Performance Programming in C# and .NET

High-Performance Programming in C# and .NET

by Jason Alls

Writing high-performance code while building an application is crucial, and over the years, Microsoft has focused on delivering various performance-related improvements within the .NET ecosystem. This book will help you understand the aspects involved in designing responsive, resilient, and high-performance applications with the new versi...

Price:  $49.99  |  Publisher:  Packt Publishing  |  Release:  2022

The NGINX Real-Time API Handbook

The NGINX Real-Time API Handbook

by Karthik Krishnaswamy, Alessandro Fael Garcia

Discover how to deliver reliable, high-performance APIs with our NGINX Real-Time API Handbook. Compiled by leading experts on real-time API management, this handbook is a comprehensive guide to reducing latency in your applications and APIs without making any compromises. Learn why now, more than ever, your APIs need to perform in real ti...

Free ebook  |  Publisher:  Self-publishing  |  Release:  2020