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?
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.
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 . . .
A Big Win ToolkitIf your database hasn't had much optimization and is large enough, you could find 10X, 100X or even 1,000X gains.
A Cost Reduction ToolkitOne of the benefits of optimization is that you can defer database upgrades or even potentially downgrade your DB.
An Optimization FrameworkYou will be getting my framework and thought processes on how I approach optimization challenges.
Benchmarking GuidelinesYou will get the guidelines and techniques I use to validate the performance optimizations proposed.
More ConfidenceDon't be intimidated by Postgres, learn the steps you can take to improve performance and become the hero of your team.
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.
“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!”
“Whew. My DBA, @CrestonJamison from http://www.rubytreesoftware.com, saved our bacon last wk. I highly recommend him for Rails & Postgres work.”
Rob WallingFounder of Drip
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.”
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.”