No upcoming presentations...

    Getting core parameters right is essential for ensuring good performance and stability from your PostgreSQL database. As PostgreSQL is now approaching 400 parameters that can be set in addition to OS, kernel and disk options, configuring a PostgreSQL database can be a daunting task. In this beginner friendly session, we will focus on some key parameters and discuss the trade-offs between them. ...

    @ Postgres Conference 2025

    Mar 19 2025

    Essentials

    PostgreSQL Index Strategy Guide

    Tips and Strategies

    Indexes are the backbone of efficient data retrieval in PostgreSQL, but their effective use requires more than just knowing how to create them. Do you ever feel like your database is stubbornly refusing to use your carefully crafted index? Does size really matter? How much of an impact does over-indexing have?

    We will kickstart by understanding how indexes work and why the database may choos...

    @ Postgres Conference 2025

    Mar 21 2025

    Ops

    Effective lock management is important for any database’s performance and stability. This presentation offers an exploration of some pitfalls and solutions to the Lock Manager challenges related to large, high performance environments.

    We begin by examining how table inheritance can multiply the number of locks, and how that can affect performance when dealing with more than 10,000 locks. We...

    @ Postgres World Webinar Series 2024

    Jun 12 2024

    Ops

    Advanced strategies for PostgreSQL Lock Management

    Beyond the Deadlock: Examining Complex Lock Scenarios in PostgreSQL

    Effective lock management is important for any database’s performance and stability. This presentation offers an exploration of some pitfalls and solutions to the Lock Manager challenges related to large, high performance environments.

    We begin by examining how table inheritance can multiply the number of locks, and how that can affect performance when dealing with more than 10,000 locks. We...

    @ Postgres Conference 2024

    Apr 18 2024

    Ops