TALK2022-04 Orca. A Modular Query Optimizer Architecture for VMware Greenplum (Venkatesh Raghavan)

Описание

TALK2022-04 Orca. A Modular Query Optimizer Architecture for VMware Greenplum (Venkatesh Raghavan)

00:00 Start
00:10 Introduction
01:23 Overview
02:50 Who am I
03:57 Greenplum
05:52 Random
07:07 Partitioning
09:33 Disclaimers
09:48 Live Journey
10:23 Query Optimization
11:00 Why Orca
15:03 Query Optimizer
15:54 Performance
17:54 Postgres
18:53 Orca vs Postgres
22:23 Orca Communication
23:33 Metadata Provider API
24:58 Constant Expression Evaluation
26:16 Multiple Databases
26:46 Modular and extensible
27:56 Optimization tools
29:32 Steps in query processing
30:32 Preprocessing
32:52 Expiration
34:23 Join Order
35:36 Required Properties
41:42 Physical Implementation
47:27 Whats Next
52:26 Orca Code