Please enter username and password to log in.
Год издания: 2015
Автор: Jayadevan Maymala
Издательство: Packt Publishing
Качество: Издательский макет или текст (eBook)
Интерактивное оглавление: Да
Количество страниц: 272
Описание: 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 PostgreSQL's advanced features will save you work and increase performance, once you've 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, you'll 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.
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)
1: Installing PostgreSQL
2: Server Architecture
3: PostgreSQL – Object Hierarchy and Roles
4: Working with Transactions
5: Data Modeling with SQL Power Architect
6: Client Tools
7: SQL Tuning
8: Server Tuning
9: Tools to Move Data in and out of PostgreSQL
10: Scaling, Replication, and Backup and Recovery
11: PostgreSQL – Troubleshooting
12: PostgreSQL – Extras
If you like the topic, please click share to help develop our site.
To download the file disable ad blocking, and reload the page.How to disable ad blocking?
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum