Stateful on Kubernetes: Running Postgres the Right Way
We dig into the failure scenarios teams overlook, the trade-offs between self-managed and operator-managed approaches, and what it takes to build a Kubernetes-native Postgres setup you can actually trust in production.
Building Postgres High Availability That Holds Up Under Pressure
We dig into the scenarios teams most often overlook: replication lag during a failover, split-brain risks, fencing a demoted primary, and why automated failover can make an outage worse if not done carefully.
Exploring the Consistency-Availability-Partition (CAP) Theorem
In this webinar, we will explore the trade-offs that you need to make when drawing an architecture for a Relational Database Management System like PostgreSQL. We will conclude with some practical use cases, explaining the constraints, the problems and how we solve them.
Beyond Joins and Indexes: Explaining the Postgres Query Optimizer, Part 2
As a follow up to the presentation, Explaining the Postgres Query Optimizer, this webinar covers the details of query optimization, optimizer statistics, joins, and indexes. This talk covers 42 other operations the optimizer can choose to handle complex queries, large data sets, and to enhance performance. These include merge append, gather, memoize, and hash aggregate. It explains their purpose and shows queries that can generate these operations.
The query optimizer is considered the brain of the Postgres database, interpreting SQL queries and determining the optimal method of execution. In this webinar, Bruce Momjian, Postgres Evangelist will cover how the query optimizer interprets queries using the EXPLAIN command. Join this webinar to better understand how you can improve querying behavior using the optimizer.
Data Analytics in the Cloud with Postgres Window Functions
It was far more than just a lucky break that Postgres has become so well-respected for its exceptional analytics capabilities. The Window function is one of the driving forces behind this success—it enables users to quickly and easily execute complex queries and calculations to gain valuable insights with minimal effort. That’s what spurred Bruce Momijian VP, Postgres Evangelist, and co-founder of the PostgreSQL community and Marc Linster, EDB CTO, to put together their latest webinar to extensively demonstrate the Postgres Window function.
Database Downtime: The Major Ways Your Database is Hurting Your Brand and Customer Experience
In this 45-minute webinar, hosted by Celest Turner Hall, EDB senior leaders Kelly Poole, Jerry Hemenway and Tom Rieger will discuss the major ways your database architecture could be failing your business, causing frustrating planned or unplanned downtime, increasing regulatory or monetary risks and even data non-compliance.
