Secrets of PostgreSQL Performance

A session at DjangoCon US 2011

Tuesday 6th September, 2011

4:20pm to 5:00pm

PostgreSQL is effectively the default RDBMS for Django. Learn the dark arts of optimizing this powerful database to be blazingly fast on your own hardware or in the cloud.

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

About the speaker

This person is speaking at this event.
Frank Wiles

Open Source Consultant specializing in scaling and performance. Python, Django, PostgreSQL. President and Founder of @revsys bio from Twitter

Coverage of this session

Sign in to add slides, notes or videos to this session

Tell your friends!


Time 4:20pm5:00pm PST

Date Tue 6th September 2011

Short URL


Official session page


View the schedule



See something wrong?

Report an issue with this session