NorthEast Ohio Oracle Users Group

September 5, 2025
Half Day PostgreSQL Conference


Lukas Fittl, founder & CEO of pganalyze, will present "PostgreSQL Performance Tuning Best Practices". Rumpi Gravenstein SBS Architect will present "Trip Hazards on your path to PostgreSQL.

Presenter : Lukas Fittl - PostgreSQL Performance Tuning Best Practices1:00 PM - 2:00 PM
Presenter : Rumpi Gravenstein - Trip Hazards on Your Path to PostgreSQL2:30 PM - 3:30 PM

Featured Presentations

PostgreSQL Performance Tuning Best Practices (virtual presentation), Lukas Fittl

Educate yourself on query performance tuning best practices. Topics that will be covered include:
  • How to go from a slow query to a query plan that shows which exact part was slow
  • Why BUFFERS is important, and how to interpret the hits counter
  • How to identify when plans fall over to a bad query plan and why this can happen
  • How to rewrite queries based on plans to speed up performance
  • The different planner settings and how they influence plan choices
  • Identifying bad row estimates in a query, and how to correct them with better statistics
  • Using statistics on expressions to help queries that use JSONB
  • Identifying alternate plans using planner hints with pg_hint_plan, and how it compares toOracle’s hint mechanism
  • Other ways of overriding the Postgres planner choices
  • Parameterized Index Scans, and how they are influenced by the join order and join type
  • Existing and upcoming pganalyze functionality for optimizing slow queries and working with EXPLAIN plans
The presentation ends with an open Q&A period.

Speaker Bio:

Lukas Fittl is the founder and CEO of pganalyze, an independent software company trusted by leading engineering teams, like Atlassian, Fivetran, & AutoTrader, to monitor and optimize PostgreSQL performance in production. He launched pganalyze in 2012 after years of hands-on experience tuning databases and building infrastructure tools. Prior to pganalyze, Lukas held engineering and product leadership roles at Microsoft, Citus Data, and Product Hunt, where he worked on scalable database systems. Lukas has been recognized with multiple PostgreSQL contributions and is known for sharing technical insights through talks, articles, and his popular “5 Minutes of Postgres” YouTube series.

Trip Hazards on Your Path to PostgreSQL

PostgreSQL continues to gain popularity as a robust, SQL-compliant database. As more developers transition between Oracle and PostgreSQL, understanding the key differences becomes increasingly important. In this session, Rumpi Gravenstein will highlight unique PostgreSQL behaviors that have surprised even seasoned professionals. By the end of the presentation, attendees will walk away with a curated list of PostgreSQL "features" to watch out for—helping you avoid common pitfalls and write more effective application

Speaker Bio:

Rumpi Gravenstein brings over 35 years of database expertise to his role as Publishing Architect at Snap-on Business Solutions. He has spent the past five years working extensively with PostgreSQL, following three decades of deep experience with Oracle technologies. Rumpi is a seasoned presenter, having delivered numerous sessions at both regional and national user group conferences, where he shares practical insights and lessons learned from real-world implementations.