课程概览

PostgreSQL（或Postgres）是最受欢迎的开源关系数据库之一。 在培训结束后，参与者将能够： 使用高级管理技术来配置和管理PostgreSQL服务器优化数据库和查询以获得最佳性能复制并缩放PostgreSQL服务器 听众 数据库管理员系统管理员具有数据库经验的开发人员 课程的 格式 部分讲座，部分讨论，练习和沉重的练习 注意 本课程基于PostreSQL 9，但可以适应不同的版本

课程大纲

Introduction

PostgresSQL Setup and Configuration

Overview of PostgreSQL Architecture and Advanced Features

PostgreSQL Administration

· Connecting to the Database

· Overview of PgAdmin III

· Configuring the Server

· Setting up and Managing Users

· Overview of Database Object Types

· Setting Permissions & Security

· Querying the Database

· Monitoring the Database

· Ensuring Atomicity and Isolation

· Backing up and Restoring PostreSQL

· Migrating Data to Another System

· Working with PostreSQL Logs

Performance Optimization

· Reducing I/O with HOT

· Locking & Concurrency

· Evaluating the Design of the Database

· Optimizing SQL Queries with EXPLAIN

· Inspecting the Workload

· Benchmarking and Profiling

· Optimzing Joins

· Using Indexes Efficiently

PostgreSQL Replication

· Overview of PostgreSQL Replication

· High Availability in PostgreSQL

· Streaming Replication

· Managing Clusters Using repmgr

· Running Queries on Database in Hot Standby

· Synchronous Replication

· File based Log Shipping

· Trigger-based Logical Replication with Slony & Londiste

· Connection Pooling

· Upgrading PostgreSQL

· Sharding and Scaling PostgreSQL

Summary and Conclusion