The 30 Minute PostgreSQL Tune-Up

*

Excerpt

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?

Description

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.

Speaking experience

Speaker

  • Headshot

    Josh Berkus

    PostgreSQL Project

    Biography

    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.

    Sessions