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.

Похожее
NoSQL DISTILLED. A Brief Guide to the Emerging World of Polyglot Persistence
Автор: Martin Fowler, Pramod J. Sadalage
Год: 2013
Необходимость обрабатывать все более крупные объемы данных является одним из факторов, влияющих на внедрение нового класса нереляционных баз данных NoSQL. Сторонники баз NoSQL утверждают, что их можно использовать для создания более производительных, легче масштабируемых и проще программируемых систем.В этой книге...
Practical Entity Framework
Автор: Brian L. Gorman
Год: 2020
Determine your object relational mapper (ORM) of choice for enterprise applications using .NET Framework, and especially .NET Framework Core 3.1 and higher. Real-world examples and considerations are presented in this book to help you create robust and efficient database solutions....
PostgreSQL 9.0 High Performance
Автор: Gregory Smith
Год: 2010
PostgreSQL database servers have a common set of problems they encounter as their usage gets heavier and requirements more demanding. You could spend years discovering solutions to them all, step by step as you encounter them. Or you can just...
PostgreSQL Administration Cookbook, 9.5/9.6 Edition
Автор: Simon Riggs, Gianni Ciolli, Gabriele Bartolini
Год: 2017
PostgreSQL is a powerful opensource database management system; now recognized as the expert's choice for a wide range of applications, it has an enviable reputation for performance and stability. PostgreSQL provides an integrated feature set comprising relational database features, object-relational,...
Написать сообщение
Тип
Почта
Имя
*Сообщение