M PostgreSQL for Data Architects

Discover how to design, develop, and maintain your database application effectively with PostgreSQL
1. Auflage 2025
ISBN: 978-1-78328-861-8
Verlag: De Gruyter
Format: PDF
Kopierschutz: Adobe DRM (»Systemvoraussetzungen)

E-Book, Englisch, 272 Seiten

Key FeaturesBook 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.

Autoren/Hrsg.

M, Jayadevan

Fachgebiete

• Mathematik | Informatik EDV | Informatik EDV & Informatik Allgemein

Über Autor(innen)

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.