The 30 Minute PostgreSQL Tune-Up*
So, now that your application is in production, the default PostgreSQL settings installed on a generic EC2 VM aren't quite cutting it. What do you need to do to make PostgreSQL perform?
So, now that your application is in production, the default PostgreSQL settings installed on a generic EC2 VM aren’t quite cutting it. What do you need to do to make PostgreSQL perform?
Don’t dispair! You can learn enough in 30 minutes to greatly improve the performance of your database server. PostgreSQL guru Josh Berkus will give you five minutes each on:
- Choosing hardware
- Configuring Linux
- The 10 PostgreSQL.conf settings to care about
- Connection pooling
- Index Overhaul
- Fixing your application
A well-tuned PostgreSQL server can do 15,000 queries a second — or more! Learn enough to get started tuning yours.
Josh Berkus is best known as a Core Team member of the world-spanning PostgreSQL project. He is CEO of PostgreSQL Experts, Inc. and in his 12 years as a database consultant he has worked with CouchDB, MySQL, Oracle, and MSSQL Server as well as Postgres, and is heavily involved in many OSS communities, including BIRT, OSCON, OSfA, Noisebridge and more. He’s also a potter and a mean cook.
- Title: Give a Great Tech Talk
- Track: Culture
- Room: B304
- Time: 1:30 – 3:15pm
Why do so many technical presentations suck? Make sure that yours doesn’t. Josh Berkus and Ian Dees will show you how to share your ideas with your audience by speaking effectively and (when the situation warrants it) showing your code.
- Speakers: Ian Dees, Josh Berkus