PostgreSQL Database Administration on Win/Linux-Part 3 (PT)

PostgreSQL Database Administration : Walk-in a Beginner, Walk-Out an Expert (Performance Tuning)

Created by: Sadiq Basha
Senior Production Database Administrator

What Will I Learn?

• PostgreSQL Installation from Source Code.
• Segregation of PostgreSQL Files and Best Practices.
• Performance tuning PostgreSQL Server Parameters.
• Query Optimization.
• Performance Monitoring and Events.
• Optimizer and Extended Statistics.
• Error Reporting and logging.
• PgBadger.
• Pg_Buffercache.
• Pg_Prewarm.
• Internals of Shared Buffers and Clock Sweep Algorithm.

Requirements

• Basic Knowledge of Database Concepts
• PostgreSQL Database Administration on Windows/Linux- Part 1
• Working Knowledge on Windows and Linux
• Internet access is required to download PostgreSQL Server

Target audience

• Database Administrators
• Accidental DBA's
• Developers
• Architects and Analyst
• Students
• Anyone who is curious about PostgreSQL