Greg Dostatni
Database Administrator at Command Prompt
Greg is an experienced IT professional with over 20 years of experience in higher education. Starting as a developer, he worked on software to manage Search and Rescue incidents ans urban crowd movement simulations. He has a background as a DBA / System Administrator working with Oracle and PostgreSQL in Solaris and Linux. Greg has later transitioned into building and managing applications and services for a large university in Canada, including designing developing and managing large shared database environments. Greg is committed to using technology to solve problems both at home and in professional setting.
Upcoming presentations
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...
Apr 18 2024
Past presentations
This training provides a concise, high-level overview of PostgreSQL performance and maintenance essentials. Participants will learn how to configure PostgreSQL databases in both on-prem and cloud environments, best practices and common pitfalls related to maintenance tasks, as well as how to diagnose, test, and resolve performance-related issues. Delivered over two half-day sessions, this cour...
Looking for practical database support without the cost? Group Swim: PostgreSQL Edition is your chance to wade in with real-time feedback from Postgres experts. Whether you’re troubleshooting an issue, testing new ideas, or just want to hear how others are approaching PostgreSQL, this is your opportunity to check that you have the right life preservers and start building master-level strokes.
Looking for practical database support without the cost? Group Swim: PostgreSQL Edition is your chance to wade in with real-time feedback from Postgres experts. Whether you’re troubleshooting an issue, testing new ideas, or just want to hear how others are approaching PostgreSQL, this is your opportunity to check that you have the right life preservers and start building master-level strokes. ...
Looking for practical database support without the cost? Group Swim: PostgreSQL Edition is your chance to wade in with real-time feedback from Postgres experts. Whether you’re troubleshooting an issue, testing new ideas, or just want to hear how others are approaching PostgreSQL, this is your opportunity to check that you have the right life preservers and start building master-level strokes. I...
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...
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. ...
When choosing between Open Source Software (OSS) and Closed Source Software (CSS), organizations must consider factors like support, customization, security, compliance and long term cost. OSS provides flexibility and cost advantages, but may require internal expertise for maintenance and development or creative problem solving when navigating non-traditional support structures. CSS offers trad...
Proper PostgreSQL Parameters to Prevent Poor Performance
Configuration Basics for All
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. ...
Mar 19 2025
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...
Mar 21 2025
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...
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...
Apr 18 2024