Home
About NEOOUG
Membership
Events
Presentations
Annual Conference
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 Practices
1:00 PM - 2:00 PM
Presenter : Rumpi Gravenstein - Trip Hazards on Your Path to PostgreSQL
2: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.