A PostgreSQL powered database environment will help you increasing the profitability of your business and will help you to achieve your business goals.

"Teach on the Beach"
Location: Dominican Republic

This 3 day training course will focus on advanced optimization techniques for PostgreSQL. All aspects of performance tuning and PostgreSQL tuning will be covered in detail.

Content of the training course:
Storage concepts
On-disk storage areas
On-disk layout of heaps
XLog: The transaction log
CLog: The commit log
Additional storage areas
Persistent storage
Tablespaces
Optimizing reads and writes
Random vs. sequential I/O

Memory management
Caching
The internal caching algorithm
Database cache vs. kernel cache
ClockSweep vs. LRU vs. ARC
Practical consequences
Sorts and aggregates
Temporary tables
Memory contexts

Using indexes
PostgreSQL index types
The internal architecture of indexes
Partial indexes
Indexes on functions
Indexes on regular expressions
Fuzzy matching
Reducing index sizes
Full text indexing unleased
Optimizing your own indexing strategy

Execution plans
Types of SQL optimization
Exhaustive search
Genetic algorithms
Other techniques in brief
Rule based optimization
Dynamic sampling
Greedy Nearest Neighbor algorithm
Hill-Climbing
Using EXPLAIN
Understanding the output of explain
The PostgreSQL cost system
ANALYZE
Reading and understanding pg_stats
EXPLAIN ANALYZE

Internal optimization techniques
Views and subselects
Equality constraints
Optimization of Aggregates
HashAggregates vs. GroupAggregates
DISTINCT vs. GROUP BY
Optimizing IN-statements
Optimizing ORDER BY statements
Tweaking join orders
Processing outer joins
Optimizing set operations
Optimizing procedures and functions
Adjusting costs for function calls

Genetic query optimizationg
The limits of exhaustive searches
Using geqo efficiently
Avoiding geqo

Transactions and locking
Transaction Isolation
Optimizing lock behavior
Optimistic vs. pessimistic locking
FOR SHARE vs. FOR UPDATE

Partitioning
Constraint Exclusion
Efficient cleanup

Basic understand of SQL is mandatory.

The course will be held by Hans-Juergen Schoenig, a leading expert who has written 4 books on PostgreSQL. He has been in professional PostgreSQL business since 1999.

Register for this training now: email

Price: USD 1.260
Early Bird: USD 1.150

<< back