PostgreSQL 10 High Performance

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



Bookstore > Books > PostgreSQL 10 High Performance

PostgreSQL 10 High Performance
Price$44.99 - $52.81
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. (2 books)



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:  $39.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 High P...

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

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 Computing on Complex Environments

High-Performance Computing on Complex Environments

by Emmanuel Jeannot, Julius Zilinskas

With recent changes in multicore and general-purpose computing on graphics processing units, the way parallel computers are used and programmed has drastically changed. It is important to provide a comprehensive study on how to use such machines written by specialists of the domain. The book provides recent research results in high-perfor...

Price:  $7.68  |  Publisher:  Wiley  |  Release:  2014

High Performance iOS Apps

High Performance iOS Apps

by Gaurav Vaish

Ready to build mobile apps that out-perform the rest? If you're an iOS developer with app-building experience, this practical guide provides tips and best practices to help you solve many common performance issues. You'll learn how to design and optimize iOS apps that deliver a smooth experience even when the network is poor and memory is...

Price:  $33.88  |  Publisher:  O'Reilly Media  |  Release:  2016

Apache Solr High Performance

Apache Solr High Performance

by Surendra Mohan

Apache Solr is one of the most popular open source search servers available on the web. However, simply setting up Apache Solr is not enough to ensure the success of your web product. To maximize efficiency, you need to use techniques to boost Solr performance in order to return relevant results faster. You need to implement robust techni...

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

Scaling Big Data with Hadoop and Solr

Scaling Big Data with Hadoop and Solr

by Hrishikesh Vijay Karambelkar

As data grows exponentially day-by-day, extracting information becomes a tedious activity in itself. Technologies like Hadoop are trying to address some of the concerns, while Solr provides high-speed faceted search. Bringing these two technologies together is helping organizations resolve the problem of information extraction from Big Da...

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

Getting Started with Julia Programming

Getting Started with Julia Programming

by Ivo Balbaert

Julia is a new open source programming language that is used in the field of data science computing. It was created to solve the dilemma between high-level slow code and fast but low-level code, and the necessity to use both to achieve high performance. This book will give you a head start to tackle your numerical and data problems with J...

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