RU EN
Книги для разработчиков

Troubleshooting PostgreSQL

Troubleshooting PostgreSQL

Автор:
Год:
Страниц:
164
Просмотров:
1518
Troubleshooting PostgreSQL favorites 0
Описание

PostgreSQL is a powerful, open source, object-relational database system. PostgreSQL offers many advantages for your company or business over other database systems.

This book is your practical guide to understanding the advanced techniques used to handle complex data and methods to solve issues that you might face while working with PostgreSQL. We will start with discussing the issues that arise at the time of setting up PostgreSQL. The next step will be to decide which data types will be most suitable to the task at hand and optimize performance using the right ones.

We will understand how to deal with transaction locks, fuzzy matches, cursors, joins, and so on. Know the warning signs to look for, and how to avoid the most common issues before they even happen. In addition to that, specific high-level topics such as replication and Point-In-Time-Recovery will be discussed. The entire book is based on PostgreSQL 9.4 and contains up-to-date information.

Похожее
PostgreSQL High Availability Cookbook, Second Edition
Автор: Shaun M. Thomas
Год: 2017
Master over 100 recipes to design and implement a highly available server with the advanced features of PostgreSQL. Databases are nothing without the data they store. In the event of a failure – catastrophic or otherwise – immediate recovery is...
MongoDB Cookbook, 2nd Edition
Автор: Cyrus Dasadia, Amol Nayak
Год: 2016
MongoDB is a high-performance and feature-rich NoSQL database that forms the backbone of the systems that power many different organizations – it's easy to see why it's the most popular NoSQL database on the market. Packed with many features that...
Practical Azure SQL Database for Modern Developers
Автор: Mauri, D., Coriani, S., Hoffman, A., Mishra, S., Popovic, J.
Год: 2021
Here is the expert-level, insider guidance you need on using Azure SQL Database as your back-end data store. This book highlights best practices in everything ranging from full-stack projects to mobile applications to critical, back-end APIs. The book provides instruction...
PostgreSQL Developer's Guide
Автор: Ibrar Ahmed, Asif Fayyaz, Amjad Shahzad
Год: 2015
About This Book- Design efficient, real-world database solutions and extend your knowledge of database concepts.- Learn how to program using native PostgreSQL procedural languages to write custom functions.- Explore database partitioning and learn about query optimization techniques.Who This Book Is...
Написать сообщение
Тип
Почта
Имя
*Сообщение