PostgreSQL for Data Architects
Discover how to design, develop, and maintain your database application effectively with PostgreSQL
Published on 7. October 2025
272 pages
978-1-78328-861-8 (ISBN)
Description
Key Features
Book DescriptionThis 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)
Who this book is forThis 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.
Book DescriptionThis 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)
Who this book is forThis 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.
All prices
More details
Edition
Digital original
Language
English
Place of publication
Birmingham
United Kingdom
Target group
Professional and scholarly
US School Grade: College Graduate Student
Edition type
Digital original
File size
5,58 MB
ISBN-13
978-1-78328-861-8 (9781783288618)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Other editions
Additional editions
Jayadevan Maymala
PostgreSQL for Data Architects
Book
03/2015
Packt Publishing
€62.80
Shipment within 3-4 weeks
Person
M Jayadevan :
Jayadevan Maymala is a database developer, designer, and architect. He started working with the Oracle database in 1999. Over the years, he has worked with DB2, Sybase, and SQL Server. Of late, he has been working with open source technologies. His database of choice is PostgreSQL. In his career, he has worked in different domains spanning supply chain management, finance, and travel. He has spent an equal amount of time working with databases supporting critical transaction processing systems as well as data warehouses supporting analytical systems. When he is not working on open source technologies, he spends time reading and updating himself on economic and political issues.
Jayadevan Maymala is a database developer, designer, and architect. He started working with the Oracle database in 1999. Over the years, he has worked with DB2, Sybase, and SQL Server. Of late, he has been working with open source technologies. His database of choice is PostgreSQL. In his career, he has worked in different domains spanning supply chain management, finance, and travel. He has spent an equal amount of time working with databases supporting critical transaction processing systems as well as data warehouses supporting analytical systems. When he is not working on open source technologies, he spends time reading and updating himself on economic and political issues.
Content
Table of Contents
Installation and directory structure
Server Architecture
Object Hierarchy and Security
Transactions
Data modelling with SQL Power Architect
Client Tools
SQL Tuning
Server Tuning
PostgreSQL inbuilt tools
Scaling, replication, backup and recovery
PostgreSQL - Troubleshooting
PostgreSQL - Extras
Installation and directory structure
Server Architecture
Object Hierarchy and Security
Transactions
Data modelling with SQL Power Architect
Client Tools
SQL Tuning
Server Tuning
PostgreSQL inbuilt tools
Scaling, replication, backup and recovery
PostgreSQL - Troubleshooting
PostgreSQL - Extras
