On-demand
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環境を実現します。
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.
6 indicatori chiavi per riconsiderare il tuo supporto di Postgres
I sistemi business critical richiedono un supporto che sia ugualmente business critical; occorre quindi assicurarsi che il proprio contratto di supporto offra delle garanzie adeguate. Scopri insieme a Gianni Ciolli, Vice Presidente di Solutions Architecture in EDB, quali sono i segnali che indicano di ripensare al proprio supporto Postgres.
