Поиск  
Always will be ready notify the world about expectations as easy as possible: job change page
Книги для разработчиков

PostgreSQL Administration Cookbook, 9.5/9.6 Edition

PostgreSQL Administration Cookbook, 9.5/9.6 Edition

Год:
Страниц:
556
Просмотров:
1069

Описание

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, text search, Geographical Info Systems, analytical tools for big data and JSON/XML document management.

Starting with short and simple recipes, you will soon dive into core features, such as configuration, server control, tables, and data. You will tackle a variety of problems a database administrator usually encounters, from creating tables to managing views, from improving performance to securing your database, and from using monitoring tools to using storage engines. Recipes based on important topics such as high availability, concurrency, replication, backup and recovery, as well as diagnostics and troubleshooting are also given special importance.

By the end of this book, you will have all the knowledge you need to run, manage, and maintain PostgreSQL efficiently.

What You Will Learn
- Implement PostgreSQL features for performance and reliability;
- Harness the power of the latest PostgreSQL 9.6 features;
- Manage open source PostgreSQL versions 9.5 and 9.6 on various platforms;
- Discover advanced technical tips for experienced users;
- Explore best practices for planning and designing live databases;
- Select and implement robust backup and recovery techniques;
- Explore concise and clear guidance on replication and high availability;
- See the latest details on Logical Replication and Bi-Directional Replication.

Похожее
SQL Server Query Performance Tuning, 6th Edition
Автор: Grant Fritchey
Год: 2022
Troubleshoot slow-performing queries and make them run faster. Database administrators and SQL developers are constantly under pressure to provide more speed. This new edition has been redesigned and rewritten from scratch based on the last 15 years of learning, knowledge,...
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...
Создаем динамические веб-сайты с помощью PHP, MySQL, JavaScript, CSS и HTML5
Автор: Робин Никсон
Год: 2016
Научитесь создавать интерактивные сайты, активно работающие с данными, воплощая в них мощные ком-бинации свободно распространяемых технологий и веб-стандартов. Для этого достаточно обладать базовымизнаниями языка HTML. Это популярное и доступное пособие поможет вам уверенно освоить динамическоевеб-программирование с применением самых современных языков...
Pro Oracle SQL
Автор: Karen Morton, Kerry Osborne, Robyn Sands, Riyaj Shamsudeen, Jared Still
Год: 2010
Написать сообщение
Тип
Почта
Имя
*Сообщение