Greg Dostatni

Database Administrator at Command Prompt

About

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.

Greg Dostatni has presented the following presentations

Advanced Strategies for PostgreSQL Lock Management at Postgres World Webinar Series 2024

presented by Greg Dostatni

video
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...
more
Wed 12 2024 Ops
Advanced strategies for PostgreSQL Lock Management at Postgres Conference 2024
Beyond the Deadlock: Examining Complex Lock Scenarios in PostgreSQL
presented by Greg Dostatni
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...
more
Thu 18 2024 Ops