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