Content:

Database Design

• Preparing data structures for analysis
• Data structures for data warehousing

Importing data

• Bulk loading
• LOGGED vs. UNLOGGED tables
• Tuning imports

Analytics and windowing functions

• Simple windows (rank, dense_rank, etc.)
• Frame clauses and sliding windows
• Performance tuning

Serverside business logic

• Including server side modules
• Data mining with PL/R

Performance tuning

• PostgreSQL for business intelligence
• Detecting and optimizing slow queries
• Optimizing large queries