PostgreSQL Performance Tuning Course Calendar (3 days)

PostgreSQL Performance Tuning Details | Enroll	Sep 21, 2009	Sep 23, 2009	$2,295	$1,995	Morrisville, NC
PostgreSQL Performance Tuning Details | Enroll	Nov 16, 2009	Nov 18, 2009	$2,295	$1,995	Morrisville, NC
1 Includes round-trip airfare from most commercial airports in the continental United States and some parts of Canada as well as 3 nights accommodation and shuttle services. 2 Include course and course materials only. For government and education pricing, please contact us. Enroll now

Recommended Pre-requisites

Students attending this advanced PostgreSQL course should have attended our PostgreSQL Administration class and/or have equivalent PostgreSQL Administration experience.

In addition, students should understand and be comfortable with working in the Linux environment, including managing files, compiling software, and writing/using basic shell scripts

Course Outline/Agenda

This advanced PostgreSQL training course covers the following topics:

• PostgreSQL best practices
• PostgreSQL table inheritance (including PostgreSQL 8.2 inheritance)
• Table constraints & constraint exclusion
• Using PostgreSQL's rule system.
• Table partitioning
• PostgreSQL Large Object (LOB) support
• The Oversized Attribute Storage Technique
  • Managing TOAST in PostgreSQL
• PostgreSQL Tablespace and database management
• Server activity monitoring
  • Monitoring PostgreSQL activity from the operating system
  • Using PostgreSQL's statistics collector
  • Using the pg_stat* views
  • Viewing PostgreSQL table & system locks
• Server monitoring & Performance tuning
  • Understanding PostgreSQL's BGWriter & Shared Buffers
  • Tuning PostgreSQL sort memory
  • Checkpoints & Performance
  • WAL Segment tuning
  • Query Optimization Parameters
  • PostgreSQL Disk performance tuning
• Using the PostgreSQL Query Optimizer
• Tuning the PostgreSQL query planner
  • Query optimizer parameter
  • Viewing alternate query plans
  • Gathering performance statistics
  • Disk performance tuning
• Tuning Free Space Map settings
  • Limiting FSM needs
• Tuning the Auto-Vaccum daemon (AVD)
• Optimizing the OS for PostgreSQL
  • File system optimizations
  • Benchmarking with pg_bench
• Deploying Warm Standby/Log Shipping (PostgreSQL 8.2 feature)
• Implementing PostgreSQL Query & Data Caching
  • Application scaling through data caching
  • Cache case studies
  • Installing PostgreSQL Cache components
  • Using PostgreSQL Cache functions
  • Configuring Cache servers
  • Using LISTEN/NOTIFY for event triggering
• Improving network performance with pgBouncer
• Implementing replication with Slony-I

Class Size

On-Site Delivery

This course is available for on-site delivery for groups of 3 or more students.

OTG offers discounted training for on-site courses of more than 3 students - call us at 877-258-8987 (or submit the form on the upper right side of this page) for more information.

Course Details

The Open Technology Group offers the world's most comprehensive set of PostgreSQL training, from basic user training all the way to advanced administrator training. Our PostgreSQL experts can customize courses to meet your needs at an affordable price using our vast library of PostgreSQL courseware.

Contact us today to learn more about how we can make your technology team PostgreSQL experts!

Instructional Materials

• PostgreSQL 2nd Edition

View course guide table of contents 98 KB Requires Adobe Acrobat Reader

Enroll in this course