Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Mastering PostgreSQL 10: Expert techniques on PostgreSQL 10 development and administration

Buy

Master the capabilities of PostgreSQL 10 to efficiently manage and maintain your database

Key Features

  • Your one-stop guide to mastering advanced concepts in PostgreSQL 10 with ease
  • Master query optimization, replication, and high availability with PostgreSQL
  • Extend the functionalities of your PostgreSQL instance to suit your organizational needs with minimal effort

Book Description

PostgreSQL is an open source database used for handling large datasets (big data) and as a JSON document database. This book highlights the newly introduced features in PostgreSQL 10, and shows you how you can build better PostgreSQL applications, and administer your PostgreSQL database more efficiently. We begin by explaining advanced database design concepts in PostgreSQL 10, along with indexing and query optimization. You will also see how to work with event triggers and perform concurrent transactions and table partitioning, along with exploring SQL and server tuning. We will walk you through implementing advanced administrative tasks such as server maintenance and monitoring, replication, recovery, high availability, and much more. You will understand common and not-so-common troubleshooting problems and how you can overcome them. By the end of this book, you will have an expert-level command of advanced database functionalities and will be able to implement advanced administrative tasks with PostgreSQL 10.

What you will learn

  • Get to grips with the advanced features of PostgreSQL 10 and handle advanced SQL
  • Make use of the indexing features in PostgreSQL and fine-tune the performance of your queries
  • Work with stored procedures and manage backup and recovery
  • Master replication and failover techniques
  • Troubleshoot your PostgreSQL instance for solutions to common and not-so-common problems
  • Learn how to migrate your database from MySQL and Oracle to PostgreSQL without any hassle

Who This Book Is For

If you are a PostgreSQL data architect or an administrator and want to understand how to implement advanced functionalities and master complex administrative tasks with PostgreSQL 10, then this book is perfect for you. Prior experience of administrating a PostgreSQL database and a working knowledge of SQL are required to make the best use of this book.

Table of Contents

  1. PostgreSQL Overview
  2. Understanding transactions and locking
  3. Making use of indexes
  4. Handling advanced SQL
  5. Logfiles, system statistics and monitoring
  6. Optimizing for good query performance
  7. Writing stored procedures
  8. Managing PostgreSQL security
  9. Handling backup and recovery
  10. Setting up replication
  11. Useful extensions
  12. Troubleshooting PostgreSQL
  13. Migrating to PostgreSQL
(HTML tags aren't allowed.)

Learning the UNIX Operating System (Nutshell Handbook)
Learning the UNIX Operating System (Nutshell Handbook)
If you are new to UNIX, this concise introduction will tell you just what you need to get started and no more. Why wade through a 600-page book when you can begin working productively in a matter of minutes? It's an ideal primer for Mac and PC users of the Internet who need to know a little bit about UNIX on the systems they visit.

This book is...

Multi-criteria Decision Analysis: Methods and Software
Multi-criteria Decision Analysis: Methods and Software
People face making decisions both in their professional and private lives. A manager in a company, for example, may need to evaluate suppliers and develop partnerships with the best ones. A household may need to choose an energy supplier for their family home. Students cannot ignore university rankings. Often candidates for a job...
XNA 3.1 Game Development for Teens
XNA 3.1 Game Development for Teens

XNA 3.0 GAME DEVELOPMENT FOR TEENS is a complete guide to entry level programming and computer game development using XNA 3.0 and the Visual C# 2008 Express programming language for beginners. This book shows readers how to create and execute computer games on their PC, and then how to port their PC games over to their Xbox 360 or Zune...


Fuzzy Logic in Financial Analysis (Studies in Fuzziness and Soft Computing)
Fuzzy Logic in Financial Analysis (Studies in Fuzziness and Soft Computing)

With ever increasing frequency, financial studies in business are acquiring greater importance in the field of management as a consequence of the complexity of the problems arising in present day society. The old treaties that included certain aspects on the raising and placing of payment means have been relegated to history, leaving the way...

Windows Server 2008: The Definitive Guide
Windows Server 2008: The Definitive Guide
This practical guide has exactly what you need to work with Windows Server 2008. Inside, you'll find step-by-step procedures for using all of the major components, along with discussions on complex concepts such as Active Directory replication, DFS namespaces and replication, network access protection, the Server Core edition, Windows PowerShell,...
Micro-ISV: From Vision to Reality
Micro-ISV: From Vision to Reality
In February 2005, after releasing my first commercial application, I went looking for all sorts of
information that would help me market, support, and improve my product. I wasn’t especially
happy with what I found.

There were books aplenty on starting retail businesses, restaurants, inns—you name it—...
©2021 LearnIT (support@pdfchm.net) - Privacy Policy