2 2 1 4 5 - 9 2 65511 - 153 2 1 1 - 5 ## A high-level introduction to the query planner in PostgreSQL Richard Guo / OpenPie ## Agenda • About OpenPie and Me • What Does Planner Do? • Phases of and fully adaptable distributed HTAPingzhou database capabilities ## About Me ## Richard Guo • PostgreSQL Contributor • OpenPie/Pivotal ## Overall Backend Structure ## • Parser Determines the semantic

## TGT 服务器的优化 ## 块设备协议 • NBD • Linux专有块设备协议 • iSCSI • 广泛支持的外部设备协议（块，磁带等） ## Curve云原生存储支持块设备 • 通过NBD，只支持Linux - 通过SDK API，目前只支持Linux - PFS · 扩大使用范围 - 通过iSCSI支持更多系统，例如Windows, 类UNIX系统等，使用两项基础技术 iscsi initiator，系统自带 • Linux open-iscsi • Windows iSCSI 发起者 • 服务器端 • 必须是CurveBS原生支持的平台，因为需要curve原生接口，目前是Linux ## iSCSI target服务器 • LINUX LILO • 一般用于输出内核本地块设备 • TCMU • 作为LILO支持用户态的接口 • 如何评价LILO brpc, c++, protobuf 等) • TCMU多了一层转接，配置过程复杂，业界踩的坑不够多。 • TCMU的用户态代码会受到框架约束，不够灵活。 ## iSCSI target 服务器 • TGT(STGT) • 比较久的历史，原来叫STGT，后来改成TGT • 纯用户态，不与内核绑定 - 支持复杂的存储系统，例如Ceph RBD, sheepdog, Glfs • 纯C代码，外加一些脚本

## RUST CHINA CONF 2023 第三届中国Rust开发者大会 6.17-6.18 @Shanghai ## 用 egg 孵化你的 SQL 优化器 王润基 RisingWave 内核开发工程师 ## RisingLight ## An Educational OLAP Database System ## RisingLight 查询引擎的整体结构  ## 一 个 SQL 语句优化的例子 SQL Physical Plan  ## 查询优化 ## 基于规则的优化 (RBO)  谓词下推 ## 基于代价的优化 (CBO)  连接重排序 Join

## AMD # 从汇编角度看编译器优化 by 彭于斌 (@archibate) 往期录播：https://www.bilibili.com/video/BV1fa411r7zp 课程 PPT 和代码：https://github.com/parallel101/course  ## 高性能并行编程与优化 - 课程大纲 • 分为前半段和后半段，前半段主要介绍现代 C++，后半段主要介绍并行编程与优化。 1. 课程安排与开发环境搭建：cmake 与 git 入门 2. 现代 C++ 入门：常用 STL 容器，RAII 内存管理 3. 现代 C++ 进阶：模板元编程与函数式编程 4. 编译器如何自动优化：从汇编角度看 C++ 5. C++11 起的多线程编程：从 起的多线程编程：从 mutex 到无锁并行 6. 并行编程常用框架：OpenMP 与 Intel TBB 7. 被忽视的访存优化：内存带宽与 cpu 缓存机制 8. GPU 专题：wrap 调度，共享内存，barrier 9. 并行算法实战：reduce，scan，矩阵乘法等 10. 存储大规模三维数据的关键：稀疏数据结构 11. 物理仿真实战：邻居搜索表实现 pbf 流体求解 12

PostgreSQL 9.4.26 Documentation The PostgreSQL Global Development Group #### PostgreSQL 9.4.26 Documentation by The PostgreSQL Global Development Group Copyright © 1996-2020 The PostgreSQL Global Development Development Group ## Legal Notice PostgreSQL is Copyright © 1996-2020 by the PostgreSQL Global Development Group. Postgres95 is Copyright © 1994-5 by the Regents of the University of California. Permission xlii 1. What is PostgreSQL? ..... xlii 2. A Brief History of PostgreSQL ..... xliii 2.1. The Berkeley POSTGRES Project ..... xliii 2.2. Postgres95 ..... xliii 2.3. PostgreSQL ..... xliv 3. Conventions

PostgreSQL 14.10 Documentation The PostgreSQL Global Development Group ### PostgreSQL 14.10 Documentation The PostgreSQL Global Development Group Copyright $ \copyright $ 1996–2023 The PostgreSQL PostgreSQL Global Development Group ## Legal Notice PostgreSQL is Copyright © 1996–2023 by the PostgreSQL Global Development Group. Postgres95 is Copyright © 1994–5 by the Regents of the University of California xxxii 1. What Is PostgreSQL? ..... xxxii 2. A Brief History of PostgreSQL ..... xxxii 2.1. The Berkeley POSTGRES Project ..... xxxiii 2.2. Postgres95 ..... xxxiii 2.3. PostgreSQL ..... xxxiv 3

PostgreSQL 12.17 Documentation The PostgreSQL Global Development Group ### PostgreSQL 12.17 Documentation The PostgreSQL Global Development Group Copyright $ \copyright $ 1996-2023 The PostgreSQL PostgreSQL Global Development Group ## Legal Notice PostgreSQL is Copyright © 1996-2023 by the PostgreSQL Global Development Group. Postgres95 is Copyright © 1994-5 by the Regents of the University of California xxxiii 1. What Is PostgreSQL? ..... xxxiii 2. A Brief History of PostgreSQL ..... xxxiv 2.1. The Berkeley POSTGRES Project ..... xxxiv 2.2. Postgres95 ..... xxxiv 2.3. PostgreSQL ..... xxxv 3.

PostgreSQL 9.0.22 Documentation The PostgreSQL Global Development Group #### PostgreSQL 9.0.22 Documentation by The PostgreSQL Global Development Group Copyright © 1996-2015 The PostgreSQL Global Development Development Group ## Legal Notice PostgreSQL is Copyright © 1996-2015 by the PostgreSQL Global Development Group and is distributed under the terms of the license of the University of California below lvi 1. What is PostgreSQL? ..... lvi 2. A Brief History of PostgreSQL ..... lvii 2.1. The Berkeley POSTGRES Project ..... lvii 2.2. Postgres95 ..... lviii 2.3. PostgreSQL ..... lviii 3. Conventions

PostgreSQL 8.3.23 Documentation The PostgreSQL Global Development Group #### PostgreSQL 8.3.23 Documentation by The PostgreSQL Global Development Group Copyright © 1996-2013 The PostgreSQL Global Development Development Group ## Legal Notice PostgreSQL is Copyright © 1996-2013 by the PostgreSQL Global Development Group and is distributed under the terms of the license of the University of California below xlviii 1. What is PostgreSQL? ..... xlviii 2. A Brief History of PostgreSQL ..... xlix 2.1. The Berkeley POSTGRES Project ..... xlix 2.2. Postgres95 ..... l 2.3. PostgreSQL ..... l 3. Conventions

PostgreSQL 8.1.11 Documentation The PostgreSQL Global Development Group #### PostgreSQL 8.1.11 Documentation by The PostgreSQL Global Development Group Copyright © 1996-2005 The PostgreSQL Global Development Development Group ## Legal Notice PostgreSQL is Copyright © 1996-2005 by the PostgreSQL Global Development Group and is distributed under the terms of the license of the University of California below Preface xxxviii 1. What is PostgreSQL? xxxviii 2. A Brief History of PostgreSQL xxxix 2.1. The Berkeley POSTGRES Project xxxix 2.2. Postgres95.xl 2.3. PostgreSQL.xl 3. Conventions.xl 4. Further