background

Ludicrous Speed Postgres

A Postgres performance optimization course focused on optimizing your schema and database usage.

Forget lightspeed. You need ludicrous speed. If you have put off learning how to optimize your Postgres database because you thought it would take too long or would be too hard, wait no more. I am designing this course to be the most efficient way to turn you into a Postgres performance master. Whether you need to optimize certain areas of your application or want to drop your overall database utilization, this course can help.

Enrollment Has Closed

Who is this course for?

Senior Developers

If you have put off learning how to best leverage the Postgres database you use everyday or want to take your knowledge to the next level, this course is a perfect fit for you. Some of my consulting engagements have resulted in query improvements by as much as 1,000 to 10,000 percent. Imagine the type of impact that could have in your organization.

Junior Developers

Do you use Postgres? Do you want to leap frog your fellow developers in terms of optimizing performance? With today's "big data" there is no better way than learning how to optimize your use of your Postgres database. If you have not had experience with a multi-terabyte database with billions of rows for some tables, that is what we will be using in this course to demonstrate optimization methods.

Database Administrator (Even Accidental?)

While this course will not be covering PostgreSQL configuration much if at all, we will give advice on schema changes, index selection and statement usage to get the most performance out of your database. Use this knowledge to help drop your database's CPU and disk activity. Some of my consulting engagements have resulted in dropping CPU utilization from 80% to 20% during active periods.

If any of these sound like you, you are in the right place!

By the end of course you will have . . .

Big Data Experience

You will have learned how to optimize a multi-terabyte database — some tables with billions of rows.

A Big Win Toolkit

If your database hasn't had much optimization and is large enough, you could find 10X, 100X or even 1,000X gains.

A Cost Reduction Toolkit

One of the benefits of optimization is that you can defer database upgrades or even potentially downgrade your DB.

An Optimization Framework

You will be getting my framework and thought processes on how I approach optimization challenges.

Benchmarking Guidelines

You will get the guidelines and techniques I use to validate the performance optimizations proposed.

More Confidence

Don't be intimidated by Postgres, learn the steps you can take to improve performance and become the hero of your team.
Image

Who am I?

Hi! I am Creston Jamison. I got started using Microsoft SQL Server in the late 1990's, switched to Oracle in the early 2000's and have been using PostgreSQL since about 2008 (over 15 years!). About 8 years or so ago I started doing PostgreSQL consulting. I started "Scaling Postgres" (my weekly show on scaling Postgres) in 2018. I just hit a huge milestone by recording my 300th episode!

I currently help clients optimize the performance of their PostgreSQL databases. I have helped clients find 10,000X performance wins and helped manage their multi-terabyte databases with trillions of rows.

  • Image
    “Just wanted to let you know that I made the changes to the database this morning, and the performance is fantastic. Thanks for your insight!”
    Darin Haener
    Developer
  • Image
    “Whew. My DBA, @CrestonJamison from http://www.rubytreesoftware.com, saved our bacon last wk. I highly recommend him for Rails & Postgres work.”
    Rob Walling
    Founder of Drip
  • Image
    Previous Ansible Course: “I’ve read many different blog posts and tutorials on Rails deployment and server config, and your series was what finally helped me construct a working solution and deploy my first non-Heroku app! Really appreciate your very clear, well explained instructions.”
    Joshua Steele
    Developer
  • Image
    Previous Ansible Course: “The course is very well explained and all the commands are in the outline. In addition, it not only covers server setup, but also security (ssl) and a database backup strategy. At the end of the course, you have a server that is secure with a backup plan.”
    Anthony Candaele
    Developer