PostgreSQL 10 High Performance
Expert techniques for query optimization, high availability, and efficient database maintenance
Price | $44.99 - $48.37
|
Rating | |
Authors | Ibrar Ahmed, Gregory Smith, Enrico Pirozzi |
Publisher | Packt Publishing |
Published | 2018 |
Pages | 508 |
Language | English |
Format | Paper book / ebook (PDF) |
ISBN-10 | 1788474481 |
ISBN-13 | 9781788474481 |
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.
- Ibrar Ahmed
- Gregory Smith (3 books)
- Enrico Pirozzi (2 books)
4 5 7
Similar Books
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
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
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
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
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
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
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
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