Andrew Atkinson presenting at PgDay Chicago 2023 Presenting at PgDay Chicago 2023. Photo by Hettie D.

Hi 👋

Andrew Atkinson Consulting (Refined Pages, LLC), provides software engineering design and optimization services for startups.

We specialize in helping startups and mid-sized companies scale their PostgreSQL databases and web application platforms, without costly rewrites.

By increasing the performance, reliability, efficiency of their systems, startups maximize their infrastructure spend, avoid costly downtime incidents, and deliver great user experiences, providing predictable revenue and user expansion.

Why work with me?

I’ve optimized multi-terabyte PostgreSQL databases running thousands of queries per second, removing unnecessary data, improving visibility into the operations, and I’m eager to bring this experience to your company’s platform.

I’ve written a bestselling book High Performance PostgreSQL for Rails (Pragmatic Programmers 2024) to help backend engineers learn how to better operate high performance PostgreSQL backed web applications.

What will we work on?

First we’ll create an assessment of the data and operational health of your system. We’ll identify opportunities to improve performance, observability, and reliability, and reduce cost.

📊 Problematic queries with high latency
💾 Unneeded data removal and optimizations for the schema, query, and indexes
🐘 Online data migrations, backfills, and transformations for efficiency and growth management
👨 Training and support for the full-time team members on PostgreSQL, SQL, and Active Record
🔎 Improved operational visibility and optimized tunable parameter values

Recommendations 🤝

Andrew helped us tune PostgreSQL parameters, build our multi-database integration, and optimize queries. - Brendan, VP of Engineering

Working with Andy was super easy and very helpful. I got a deep insight into how Postgres works for the specific problem we were looking at, and what solutions we could implement. Sameer, CTO, Canopy Analytics

I wanted to fill some knowledge gaps on the team around some Postgres topics. Andrew’s book was the first thing we reached for but we also brought him in to deliver two sessions of live training on some advanced topics. This gave us the opportunity to ask questions, delve deeper, and ensure everyone understood the material. Jamie, CTO, Podia

We hired Andrew to help us better understand the PostgreSQL database operations for our Rails apps. Andrew helped us look at a variety of issues and provided guidance and recommendations. - Kevin, CTO, Clearscope

Andrew provided our team with training on query plans and indexes, then rewrote an important query, greatly improving the performance. - John, Director of Engineering

Let’s Talk

Contact me to get the process started, and I’ll send over a questionnare and some pre-meeting documents for your review.

I’m looking forward to learning how I can help, and thanks for taking a look!

F.A.Q.

Tools and systems we'll use
  • I’ll need access to your databases or database observability tools (PgHero, PgAnalyze, Performance Insights, etc.). For databases, we can use a non-production instance or a read-replica, depending on your goals.
  • For code contributions, I’ll need access to your repositories, CI/CD system, and application observability tools (APM, exception tracking)
My Qualifications

Refined Pages, LLC

Andrew Atkinson
5123 W 98th St #1325
Minneapolis, MN 55437
+1 (612) 234-7574
refinedpages.com