PostgreSQL 11. Development skill
Please sign in so that we can notify you about a reply
After reading this book, you will learn how to create dynamic corporate applications based on the latest version of the PostgreSQL DBMS, which allows analysts to easily design physical and technical aspects of system architecture. The introduction of PostgreSQL into the new functionality is given, thanks to which you can develop effective and fault -tolerant applications. The advances of PostgreSQL are described in detail, including logical replication, database clusters, performance optimization, user monitoring and management. PostgreSQL’s optimizer, configuration of DBMS to achieve high speed and transition from Oracle to PostgreSQL have not been disregarded. Transactions, blocking, index and query optimization are considered. In addition, the setting of network security, the organization of backup and replication is described. At the end of the book, information about the beneficial extensions of PostgreSQL is given.
Advanced tools and capabilities of SQL in PostgreSQL 11
Indexing in postgreSQL and query optimization
backup and recovery
Replication and methods of working out failures
Search and elimination of problems with a review of typical and not too typical problems
Transition from MySQL and Oracle to PostgreSQL
The maximum performance of your database and an easy solution to various administrative tasks
Advanced tools and capabilities of SQL in PostgreSQL 11
Indexing in postgreSQL and query optimization
backup and recovery
Replication and methods of working out failures
Search and elimination of problems with a review of typical and not too typical problems
Transition from MySQL and Oracle to PostgreSQL
The maximum performance of your database and an easy solution to various administrative tasks
Author:
Author:Shenig Hans-Jurgen
Cover:
Cover:Soft
Category:
- Category:Computer & Technology
Publication language:
Publication Language:Russian
Paper:
Paper:Offset
ISBN:
ISBN:978-5-97060-671-1
No reviews found