You're reading from PostgreSQL for Data Architects Discover how to design, develop, and maintain your database application effectively with PostgreSQL

Product type Paperback

Published in Mar 2015

Publisher

ISBN-13 9781783288601

Length 272 pages

Edition 1st Edition

Tools

PostgreSQL

Concepts

Database Administration

Author (1):

Jayadevan M

View More author details

Table of Contents (14) Chapters

Preface

What this book covers
What you need for this book
Who this book is for
Conventions
Reader feedback
Customer support

1. Installing PostgreSQL FREE CHAPTER

Installation options
Dependencies to compile the source
Configuring and creating the makefile
Building and creating the executables
Installing and moving the files to where they belong
Initializing a cluster
Working with extensions
Summary

2. Server Architecture

Starting with the daemon process
Understanding the shared buffer
Checkpoint
WAL and the WAL writer process
The background writer
The autovacuum launcher process
The logging process
The stats collector process
The WAL sender and WAL receiver
Sorting in memory with work_mem
Maintenance with maintenance_work_mem
Summary

3. PostgreSQL – Object Hierarchy and Roles

The PostgreSQL cluster
Understanding tablespaces
Databases, schemas, and search_path
Roles and privileges
Summary

4. Working with Transactions

Understanding transactions
PostgreSQL and MVCC
Summary

5. Data Modeling with SQL Power Architect

Tools for databases and their uses
Database design tools
Generating SQL
Summary

6. Client Tools

GUI tools and command-line tools
pgAdmin – downloading and installation
psql – working from the command line
Summary

7. SQL Tuning

Understanding basic facts about databases
Query execution components
Finding the execution plan
Optimization guidelines and catches
Summary

8. Server Tuning

Server-wide memory settings
Managing writes, connections, and maintenance
Seek/scan cost and statistics parameters
Materialized views
Partitioned tables
Summary

9. Tools to Move Data in and out of PostgreSQL

Setting up the production database – considerations
COPY
Fast loading with pg_bulkload
pg_dump
Filtering options
Summary

10. Scaling, Replication, and Backup and Recovery

Scalability
Point-in-time recovery
Summary

11. PostgreSQL – Troubleshooting

Connection issues
Authentication and permission issues
Parameter changes not effective
Query not responding
Summary

12. PostgreSQL – Extras

Interesting data types
Features over time
Summary

Index

What you need for this book

A computer with access to the Internet is mandatory. It will definitely help if the computer is running on a Unix/Linux operating system.

The rest of the chapter is locked

You're reading from PostgreSQL for Data Architects Discover how to design, develop, and maintain your database application effectively with PostgreSQL

Table of Contents (14) Chapters

What you need for this book

Authors (1)

Personalised recommendations for you

You're reading from PostgreSQL for Data Architects Discover how to design, develop, and maintain your database application effectively with PostgreSQL

Table of Contents (14) Chapters

What you need for this book

Unlock this book and the full library FREE for 7 days

Authors (1)

Personalised recommendations for you