PostgreSQL for Data Architects : Discover How to Design, Develop, and Maintain Your Database Application Effectively with PostgreSQL

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 learnCompile PostgreSQL from source and understand the PostgreSQL architectureConfigure parameters and change default settings for a PostgreSQL serverLeverage the logging mechanism to identify errors and suboptimal queriesUse replication to scale horizontallySet up backup and recovery processesTweak parameters to optimize queries and processesTroubleshoot connection errorsUse indexes and rewrite queries to improve performanceInstall and use PostgreSQL extensionsLearn 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.