Book description
Discover how to design, develop, and maintain your database application effectively with PostgreSQL
In Detail
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)
Table of contents
-
PostgreSQL for Data Architects
- Table of Contents
- PostgreSQL for Data Architects
- Credits
- About the Author
- About the Reviewers
- www.PacktPub.com
- Preface
- 1. Installing PostgreSQL
-
2. Server Architecture
- Starting with the daemon process
- Understanding the shared buffer
- Checkpoint
- WAL and the WAL writer process
- The background writer
- The autovacuum launcher process
- The logging process
- The stats collector process
- The WAL sender and WAL receiver
- Sorting in memory with work_mem
- Maintenance with maintenance_work_mem
- Summary
- 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
- Index
Product information
- Title: PostgreSQL for Data Architects
- Author(s):
- Release date: March 2015
- Publisher(s): Packt Publishing
- ISBN: 9781783288601
You might also like
book
Developing Modern Database Applications with PostgreSQL
Get up to speed with core PostgreSQL tasks such as database administration, application development, database performance …
book
Practical PostgreSQL
Arguably the most capable of all the open source databases, PostgreSQL is an object-relational database management …
book
Learning PostgreSQL
Create, develop and manage relational databases in real world applications using PostgreSQL About This Book Learn …
book
PostgreSQL 13 Cookbook
Get to grips with building reliable, scalable, and maintainable database solutions for enterprises and production databases …