Scribd
Upload
7 views

Postgres

The document discusses tuning PostgreSQL for performance. It covers topics like hardware configuration, OS configuration, PostgreSQL configuration, transactions, locks, and query tuning.

Uploaded by

d.chakol
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
7 views

Postgres

The document discusses tuning PostgreSQL for performance. It covers topics like hardware configuration, OS configuration, PostgreSQL configuration, transactions, locks, and query tuning.

Uploaded by

d.chakol
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 3

https://bun.uptrace.dev/postgres/performance-tuning.

html#logging
https://www.citusdata.com/blog/authors/samay-sharma/

TOPICS:

Introduction of PostgreSQL
• Introduction
• History
• PostgreSQL Editions & Licensing
• Architecture
• Limits
Installing PostgreSQL Server and Client
• Comparison of installation methods
• Demonstration of installation
• Database Cluster & Initializing the Database Cluster
• Hands-on installation exercise
• Hands-on Cluster Initialization
Administration Tools and Options
• psql options
• pg_env.sh
• pg-admin GUI Client
• Other PostgreSQL command line utilities
• PostgreSQL Service Management
• PostgreSQL Physical file layout
• Hands-on installation of PG-ADMIN
• Hands-on psql commands
• Hands-on Cluster management
Configuring a PostgreSQL Cluster
• Review components of a PostgreSQL cluster
• Identify available configuration files
• Changing PostgreSQL Configuration
• Identifying whether a particular configuration change needs restart or not
• Configuration Best Practices
• Hands-on Exercise
Creating & Managing Databases
• Object Hierarchy
• Creating Database
• Creating Database Objects
• Creating Schemas
• Schema Search Path
• DDL & DML
• Data Types
• Hand-on Exercise
User Security
• Creating users
• Using and assigning user roles
• User authentication
• User Authorizations
• Hands-on Exercise
Cluster Security
• Enabling remote connections to cluster
• Host-based authentication (pg_hba.conf)
• Hands-on Exercise
Tablespace
• Built-in Table Space
• User Tablespaces
• Managing Tablespaces
Backup and Recovery Methods
• Selecting an effective backup approach
• Logical backup
• Physical backup
• PITR and WAL Archiving
• Hands-on Exercise
Table Partitioning
• Table partitioning
• Table partitioning in older versions
Routine Maintenance Task
• Optimizer Statistics
• Data Fragmentation
• VACUUM
• AutoVacuum
• Full Vacuum
• ReIndex
• Cluster
• Hands-on Exercise
Data Dictionary
• System Catalog Schema
• System Information Tables
• System Information Functions
• Hands-on Exercise
• System Information Views
• System Administration Functions
• Hands-on Exercise
Performance Tuning
• Hardware Configuration
• OS Configuration
• PG State statement
• SQL Tuning and EXPLAIN statement
• 6 step query tuning
• PostgreSQL Configuration
• Transactions
• Locks
• Hands-on Exercise
Transactions and Concurrency
• What is Transaction
• ACID properties
• Isolation problems
• Isolation Levels
• Posgtres Isolation Levels
PostgreSQL Extensions

Loading and Moving Data


• Copy Command
• Hands-on Exercise
High Availability Configuration and Operation
• Setting up streaming replication
• Master-Standby replication
• Triggering failover
• Hands-on Exercise
• Setting up Logical Replication
• Hands-on Exercise
Upgrading PostgreSQL
• Minor version upgrades
• Major version upgrades
• pg_upgrade utility
PostgreSQL Migration
• Overview of Database Migration
• Available Free Migration Tools

You might also like