PostgreSQL has been the default recommended database since Django was initially released. Learn the dark arts of optimizing this powerful database. Both in general use cases and specifically for Django.

In this talk you'll learn:

• Things to avoid
  • double duty servers
  • disk contention
  • unnecessary queries

• The "Big 3" configuration options you should always adjust
  • shared_buffers
  • effective_cache_size
  • random_page_cost

• Other useful configuration options

• Hardware considerations
  • RAM, disks, and CPU
  • Rackspace Cloud vs Amazon EC2
  • tablespaces
  • SSDs

• Common Django ORM issues
  • Slow count() operations

• Indexing Tips and Tricks
  • Index types
  • Multi-column indexes
  • Partial indexes

• Performance Tools you can use
• The "Dark Arts"
  • Planner Statistics
  • materialized views
  • crazy replication