Jayadevan Maymala - PostgreSQL for Data Architects
Here you can read online Jayadevan Maymala - PostgreSQL for Data Architects full text of the book (entire story) in english for free. Download pdf and epub, get meaning, cover and reviews about this ebook. year: 2015, publisher: Packt Publishing, genre: Computer. Description of the work, (preface) as well as reviews are available. Best literature library LitArk.com created for fans of good reading and offers a wide selection of genres:
Romance novel
Science fiction
Adventure
Detective
Science
History
Home and family
Prose
Art
Politics
Computer
Non-fiction
Religion
Business
Children
Humor
Choose a favorite category and find really read worthwhile books. Enjoy immersion in the world of imagination, feel the emotions of the characters or learn something new for yourself, make an fascinating discovery.
- Book:PostgreSQL for Data Architects
- Author:
- Publisher:Packt Publishing
- Genre:
- Year:2015
- Rating:5 / 5
- Favourites:Add to favourites
- Your mark:
PostgreSQL for Data Architects: summary, description and annotation
We offer to read an annotation, description, summary or preface (depends on what the author of the book "PostgreSQL for Data Architects" wrote himself). If you haven't found the necessary information about the book — write in the comments, we will try to find it.
Discover how to design, develop, and maintain your database application effectively with PostgreSQL
About This Book- Understand how to utilize the most frequently used PostgreSQL ecosystem-related tools and technologies
- A hands-on guide focused primarily on providing a practical approach to learning about architecture and design considerations for database architects
- The book covers PostgreSQL from a data architects perspective covering topics from installation from source to designing tables using SQL Power Architect, as well as deciding replication and failover strategies.
This book is for developers and data architects who have some exposure to databases. It is assumed that you understand the basic concepts of tables and common database objects, including privileges and security.
What You Will Learn- Compile PostgreSQL from source and understand the PostgreSQL architecture
- Configure parameters and change default settings for a PostgreSQL server
- Leverage the logging mechanism to identify errors and suboptimal queries
- Use replication to scale horizontally
- Set up backup and recovery processes
- Tweak parameters to optimize queries and processes
- Troubleshoot connection errors
- Use indexes and rewrite queries to improve performance
- Install and use PostgreSQL extensions
- Learn how to leverage the command-line client (psql)
PostgreSQL is an incredibly flexible and dependable open source relational database. Harnessing its power will make your applications more reliable and extensible without increasing costs. Using PostgreSQLs advanced features will save you work and increase performance, once youve discovered how to set it up.
PostgreSQL for Data Architects will teach you everything you need to learn in order to get a scalable and optimized PostgreSQL server up and running.
The book starts with basic concepts like installing PostgreSQL from source and covers theoretical aspects such as concurrency and transaction management. After this, youll learn how to set up replication, use load balancing to scale horizontally, and troubleshoot errors.
Finally, you will get acquainted with useful tools available in the PostgreSQL ecosystem used for analyzing PostgreSQL logs, setting up load balancing, and recovery.
Jayadevan Maymala: author's other books
Who wrote PostgreSQL for Data Architects? Find out the surname, the name of the author of the book and a list of all author's works by series.