Upcoming presentations
No upcoming presentations...
Past presentations
Discover the truth about PostgreSQL by questioning everything you thought you knew! In this interactive session, we use the Socratic method to explore the internals of PostgreSQL, encouraging critical thinking and helping you uncover underlying assumptions and knowledge gaps. Through thought-provoking questions and dynamic discussions, we will challenge common myths and misconceptions about Pos...
Why PostgreSQL Isn't Utilizing Indexes: Diagnosing and Solving Performance Issues
Uncovering Hidden Bottlenecks: Optimize Queries and Boost Index Efficiency
In this session, we delve into the common scenarios where PostgreSQL may not be utilizing indexes as expected, leading to suboptimal query performance. We explore the underlying reasons, such as query optimization, data distribution, and indexing strategies, that can impact index usage. Join us as we discuss practical solutions and best practices for diagnosing and rectifying these issues, ulti...
PostgreSQL for MSSQL Server DBAs
Learn Postgres using your knowledge on SQL Server
This workshop is designed for SQL Server developers looking to expand their expertise to PostgreSQL. Discover the key differences and similarities between the two platforms, including query syntax, data types, indexing, partitioning, and performance tuning. Learn how to map SQL Server concepts like filegroups, stored procedures, and functions to PostgreSQL equivalents, and gain hands-on experie...
In this session, we delve into the common scenarios where PostgreSQL may not be utilizing indexes as expected, leading to suboptimal query performance. We explore the underlying reasons, such as query optimization, data distribution, and indexing strategies, that can impact index usage. Join us as we discuss practical solutions and best practices for diagnosing and rectifying these issues, ulti...
"Behind the Scenes: Demystifying Transaction Isolation in App Development"
PostgreSQL Isolation Levels Unveiled: Your Comprehensive Guide
Join us to understand how these Isolation levels impact the consistency, concurrency, and reliability of your database transactions. demystify the complexities of PostgreSQL isolation levels, helps you to make informed decisions in managing data integrity within your applications.
Why PostgreSQL Isn't Utilizing Indexes: Diagnosing and Solving Performance Issues"
Uncovering the Reasons Behind Suboptimal Index Usage and Optimizing PostgreSQL Query Performance
In this session, we delve into the common scenarios where PostgreSQL may not be utilizing indexes as expected, leading to suboptimal query performance. We explore the underlying reasons, such as query optimization, data distribution, and indexing strategies, that can impact index usage. Join us as we discuss practical solutions and best practices for diagnosing and rectifying these issues, ulti...
Running PostgreSQL on AWS for SQL Server DBAs
Leverage your SQL expertise to learn and manage PostgreSQL on AWS Cloud
If you are a SQL Server DBA, switching to PostgreSQL may seem like a difficult task. In this workshop, we will show you how to leverage your SQL Server expertise to run in Aurora PostgreSQL Compatible Edition and RDS for PostgreSQL. In this workshop session, learn the ins and outs of PostgreSQL administration and tips for migrating your workloads to AWS.
Optimize Costs using Babelfish for Aurora PostgreSQL
Run Microsoft SQL Server applications on PostgreSQL with little to no code change
Babelfish for PostgreSQL is an open-source project and feature of Amazon Aurora available under the Apache 2.0 and PostgreSQL licenses. It provides the capability for PostgreSQL to understand queries from applications written for Microsoft SQL Server. In this session, learn how you can optimize your licensing and maintenance costs by migrating with Babelfish for Aurora PostgreSQL without rewrit...