PostgreSQL for Data Architects

Discover how to design, develop, and maintain your database application effectively with PostgreSQL

PostgreSQL for Data Architects

Jayadevan Maymala

5 customer reviews
Discover how to design, develop, and maintain your database application effectively with PostgreSQL
eBook
$10.00
RRP $39.99
Save 74%
Print + eBook
$49.99
RRP $49.99
What do I get with a Mapt subscription?
  • Unlimited access to all Packt’s 6,000+ eBooks and Videos
  • 100+ new titles a month, learning paths, assessments & code files
  • 1 Free eBook or Video to download and keep every month after trial
What do I get with an eBook?
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with Print & eBook?
  • Get a paperback copy of the book delivered to you
  • Download this book in EPUB, PDF, MOBI formats
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
What do I get with a Video?
  • Download this Video course in MP4 format
  • DRM FREE - read and interact with your content when you want, where you want, and how you want
  • Access this title in the subscription reader
$10.00
$49.99
RRP $39.99
RRP $49.99
eBook
Print + eBook

Frequently bought together


PostgreSQL for Data Architects Book Cover
PostgreSQL for Data Architects
$ 39.99
$ 10.00
PostgreSQL High Availability Cookbook - Second Edition Book Cover
PostgreSQL High Availability Cookbook - Second Edition
$ 43.99
$ 10.00
Buy 2 for $20.00
Save $63.98
Add to Cart

Book Details

ISBN 139781783288601
Paperback272 pages

Book Description

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.

Table of Contents

Chapter 10: Scaling, Replication, and Backup 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)

Authors

Table of Contents

Chapter 10: Scaling, Replication, and Backup and Recovery

Book Details

ISBN 139781783288601
Paperback272 pages
Read More
From 5 reviews

Read More Reviews

These popular $10 titles might interest you

PostgreSQL High Availability Cookbook - Second Edition Book Cover
PostgreSQL High Availability Cookbook - Second Edition
$ 43.99
$ 10.00
PostgreSQL Administration Cookbook, 9.5/9.6 Edition Book Cover
PostgreSQL Administration Cookbook, 9.5/9.6 Edition
$ 47.99
$ 10.00
PostgreSQL Replication - Second Edition Book Cover
PostgreSQL Replication - Second Edition
$ 35.99
$ 10.00
Mastering PostgreSQL 9.6 Book Cover
Mastering PostgreSQL 9.6
$ 43.99
$ 10.00
Troubleshooting PostgreSQL Book Cover
Troubleshooting PostgreSQL
$ 23.99
$ 10.00
PostgreSQL 9.6 High Performance Book Cover
PostgreSQL 9.6 High Performance
$ 39.99
$ 10.00