欧美福利在线播放_免费在线观看羞羞视频_加勒比色老久久爱综合网_性一交一乱一区二区洋洋av_国产麻豆麻豆_国产精品一线天粉嫩av_国产精品天美传媒入口_午夜a一级毛片亚洲欧洲_精品久久久久久久大神国产_四虎影视在线播放

   PostgreSQL Administration, Optimization and Replication培訓(xùn)

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