Webinars

“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.

Explaining the Postgres Query Optimizer

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.

Postgresを活用した安心・安全なデータ保護とは～EPAS15の新機能

2022年10月にPostgreSQL15がリリースされた事を受け、EDBはEDB Postgres Advanced Server v15（以下EPAS）をローンチしました。EPAS 15は、TDE（透過的データベース暗号化） や、高セキュリティ、Oracle互換新機能を追加し、最も安全なPostgres環境を実現します。