PostgreSQL for Data Architects
| By: | Jayadevan M |
| Publisher: | Packt Publishing |
| Print ISBN: | 9781783288601 |
| eText ISBN: | 9781783288618 |
| Edition: | 1 |
| Copyright: | 2015 |
| Format: | Reflowable |
Lifetime - $52.79
eBook Features
Instant Access
Purchase and read your book immediately
Read Offline
Access your eTextbook anytime and anywhere
Study Tools
Built-in study tools like highlights and more
Read Aloud
Listen and follow along as Bookshelf reads to you
Details
Table of Contents
Book Description
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 commandline client (psql)