Postgres Uptime Starts with Failover Design: A Production Blueprint for High Availability
A Postgres database can have replicas, a failover manager, and a green dashboard, and still go down the first time the network misbehaves. Uptime isn't a feature you switch on. It comes from design decisions made across every tier between your application and your data.
EDB Korea 웨비나 시리즈 2강에서는 PostgreSQL 19의 주요 신규 기능과 EDB 제품군의 2027 로드맵을 함께 짚어봅니다. PostgreSQL 19의 핵심 변화부터 WarehousePG·PGD·CloudNativePG가 그리는 다음 단계까지, 업그레이드와 투자 계획을 세우고 계신 분들께 실질적인 기준을 제시해 드립니다.
9월 EDB Postgres AI Summit Seoul 2026에서 최고 인기 세션이었던 ClickHouse를 이번엔 실전 레벨로 깊이 파고듭니다. 컬럼 지향 저장소와 벡터화 실행으로 왜 그렇게 빠른지에서 한 걸음 더 들어가, 샤딩·복제 구조와 운영 환경에서 마주치는 테이블·인덱스·MV 설계 이슈까지 실무 중심으로 다룹니다.
“It’s not you, it’s Oracle. Leave them for Postgres”
In this 45-minute webinar, we will discuss how you can lower your software costs by as much as 80% and achieve 95% compatibility with EDB Postgres Advanced Server due to our Oracle Compatibility features. You will also learn how you could migrate in 20 person-days or less and if you are interested in moving to the Cloud, this webinar will equip you with an understanding of how EDB BigAnimal, is the fastest and most cost-effective way to go from Oracle on-premises to Postgres in the cloud.
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.