 PostgreSQL WAL日志解析与应用Log Files insert Insert xlog begin insert2 insert3 1 2 3 commit 1、2、3 Xlog flush 阻塞 数据 checkpoint 2016Postgres中国用户大会 Postgres Conference China 2016 中国用户大会  Functions of WAL0 码力 | 16 页 | 705.31 KB | 1 年前3 PostgreSQL WAL日志解析与应用Log Files insert Insert xlog begin insert2 insert3 1 2 3 commit 1、2、3 Xlog flush 阻塞 数据 checkpoint 2016Postgres中国用户大会 Postgres Conference China 2016 中国用户大会  Functions of WAL0 码力 | 16 页 | 705.31 KB | 1 年前3
 阿里云 AnalyticDB for PostgreSQL
- 打造更简单易用的Cloud SQL Data Warehouserac1 rac2 rac3 rac n Oracle RAC 11G ODPS ETL建模 交互式分析 AnalyticDB for MySQL 实时数仓 ⚫ All In One数仓去O ⚫ 交互式分析 ⚫ 中小规模实时数仓 小烟枪在阿里的场景裂变 Greenplum发展史@Alibaba 产品云化-服务中小企业  IaaS、PaaS、SaaS皆云化-大势所趋  阿里云能够提供一站式的分析解决方案 - 3 非结构化数据向量检索, “以图搜图” (规划中) 场景应用: 1、Web App把图片或者视频等非结构化数据 通过特征提取服务,提取特征向量,并写入 AnalyticDB for PG的向量表。 2、Web App检索的时,把非结构化数据通过 特征提取服务接口提取出向量,同时调用 AnalyticDB for PG的查询分析接口做查询。 特点: • 易用,结构化和非结构化数据关联查询。 for PostgreSQL AnalyticDB for PostgreSQL Client 特征提取服 务 5.检索分析 1.注册特征提取服务 3.写入url 4.生成特征 2.写入非 结构化数 OSS 音频 图片 文本 向量 ①GPU的计算性能加速 ②支持Greenplum 6.0版本 其他演进规划: 更快性能 敬请期待!0 码力 | 22 页 | 2.98 MB | 1 年前3 阿里云 AnalyticDB for PostgreSQL
- 打造更简单易用的Cloud SQL Data Warehouserac1 rac2 rac3 rac n Oracle RAC 11G ODPS ETL建模 交互式分析 AnalyticDB for MySQL 实时数仓 ⚫ All In One数仓去O ⚫ 交互式分析 ⚫ 中小规模实时数仓 小烟枪在阿里的场景裂变 Greenplum发展史@Alibaba 产品云化-服务中小企业  IaaS、PaaS、SaaS皆云化-大势所趋  阿里云能够提供一站式的分析解决方案 - 3 非结构化数据向量检索, “以图搜图” (规划中) 场景应用: 1、Web App把图片或者视频等非结构化数据 通过特征提取服务,提取特征向量,并写入 AnalyticDB for PG的向量表。 2、Web App检索的时,把非结构化数据通过 特征提取服务接口提取出向量,同时调用 AnalyticDB for PG的查询分析接口做查询。 特点: • 易用,结构化和非结构化数据关联查询。 for PostgreSQL AnalyticDB for PostgreSQL Client 特征提取服 务 5.检索分析 1.注册特征提取服务 3.写入url 4.生成特征 2.写入非 结构化数 OSS 音频 图片 文本 向量 ①GPU的计算性能加速 ②支持Greenplum 6.0版本 其他演进规划: 更快性能 敬请期待!0 码力 | 22 页 | 2.98 MB | 1 年前3
 实现PostgreSQL逻辑复制实战是否能保证备库使用WAL段之前不会 过早的移除它们 主库不会过早的清除掉掉从库正在使 用的记录 是否可以控制日志大小 复制槽技术 可以保证 可以保证 可能会造成膨胀 非复制槽 不能保证 不能保证 不会造成膨胀 复制槽技术 2016Postgres中国用户大会 Postgres Conference China 2016 中国用户大会 自定义输出插件0 码力 | 17 页 | 1.90 MB | 1 年前3 实现PostgreSQL逻辑复制实战是否能保证备库使用WAL段之前不会 过早的移除它们 主库不会过早的清除掉掉从库正在使 用的记录 是否可以控制日志大小 复制槽技术 可以保证 可以保证 可能会造成膨胀 非复制槽 不能保证 不能保证 不会造成膨胀 复制槽技术 2016Postgres中国用户大会 Postgres Conference China 2016 中国用户大会 自定义输出插件0 码力 | 17 页 | 1.90 MB | 1 年前3
 PostgreSQL 17beta1 A4 DocumentationWhere to Report Bugs ....................................................................... xxxvii I. Tutorial ......................................................................................... ............................................................................................. 1547 I. SQL Commands ..................................................................................... ...................................... 2914 I. The Source Code Repository ........................................................................... 2915 I.1. Getting the Source via Git .............0 码力 | 3017 页 | 14.45 MB | 1 年前3 PostgreSQL 17beta1 A4 DocumentationWhere to Report Bugs ....................................................................... xxxvii I. Tutorial ......................................................................................... ............................................................................................. 1547 I. SQL Commands ..................................................................................... ...................................... 2914 I. The Source Code Repository ........................................................................... 2915 I.1. Getting the Source via Git .............0 码力 | 3017 页 | 14.45 MB | 1 年前3
 PostgreSQL 17beta1 US Documentationto Report Bugs .................................................................................. xl I. Tutorial ......................................................................................... ............................................................................................. 1629 I. SQL Commands ..................................................................................... ............... 3079 I. The Source Code Repository ................................................................................ 3081 xxi PostgreSQL 17beta1 Documentation I.1. Getting the Source0 码力 | 3188 页 | 14.32 MB | 1 年前3 PostgreSQL 17beta1 US Documentationto Report Bugs .................................................................................. xl I. Tutorial ......................................................................................... ............................................................................................. 1629 I. SQL Commands ..................................................................................... ............... 3079 I. The Source Code Repository ................................................................................ 3081 xxi PostgreSQL 17beta1 Documentation I.1. Getting the Source0 码力 | 3188 页 | 14.32 MB | 1 年前3
 PostgreSQL 9.3.25 DocumentationBugs .............................................................................................lxx I. Tutorial.......................................................................................... .............................................................................................1166 I. SQL Commands...................................................................................... .............................2881 I. The Source Code Repository.............................................................................................2882 I.1. Getting The Source via Git .....0 码力 | 3002 页 | 7.47 MB | 1 年前3 PostgreSQL 9.3.25 DocumentationBugs .............................................................................................lxx I. Tutorial.......................................................................................... .............................................................................................1166 I. SQL Commands...................................................................................... .............................2881 I. The Source Code Repository.............................................................................................2882 I.1. Getting The Source via Git .....0 码力 | 3002 页 | 7.47 MB | 1 年前3
 PostgreSQL 9.3 Documentation.............................................................................................lxxv I. Tutorial.......................................................................................... .............................................................................................1236 I. SQL Commands...................................................................................... ..........................3055 I. The Source Code Repository....................................................................................................3056 I.1. Getting The Source via Git .0 码力 | 3183 页 | 7.53 MB | 1 年前3 PostgreSQL 9.3 Documentation.............................................................................................lxxv I. Tutorial.......................................................................................... .............................................................................................1236 I. SQL Commands...................................................................................... ..........................3055 I. The Source Code Repository....................................................................................................3056 I.1. Getting The Source via Git .0 码力 | 3183 页 | 7.53 MB | 1 年前3
 PostgreSQL 16.1 DocumentationWhere to Report Bugs ....................................................................... xxxvii I. Tutorial ......................................................................................... ............................................................................................. 1509 I. SQL Commands ..................................................................................... ...................................... 2872 I. The Source Code Repository ........................................................................... 2873 I.1. Getting the Source via Git .............0 码力 | 2974 页 | 14.22 MB | 1 年前3 PostgreSQL 16.1 DocumentationWhere to Report Bugs ....................................................................... xxxvii I. Tutorial ......................................................................................... ............................................................................................. 1509 I. SQL Commands ..................................................................................... ...................................... 2872 I. The Source Code Repository ........................................................................... 2873 I.1. Getting the Source via Git .............0 码力 | 2974 页 | 14.22 MB | 1 年前3
 PostgreSQL 16.1 Documentationto Report Bugs .................................................................................. xl I. Tutorial ......................................................................................... ............................................................................................. 1590 I. SQL Commands ..................................................................................... ................................... 3025 I. The Source Code Repository ................................................................................ 3027 I.1. Getting the Source via Git ...........0 码力 | 3133 页 | 14.10 MB | 1 年前3 PostgreSQL 16.1 Documentationto Report Bugs .................................................................................. xl I. Tutorial ......................................................................................... ............................................................................................. 1590 I. SQL Commands ..................................................................................... ................................... 3025 I. The Source Code Repository ................................................................................ 3027 I.1. Getting the Source via Git ...........0 码力 | 3133 页 | 14.10 MB | 1 年前3
 PostgreSQL 8.1.11 Documentation.............................................................................................xliv I. Tutorial.......................................................................................... ..............................................................................................717 I. SQL Commands...................................................................................... a different class of users, or at users in different stages of their PostgreSQL experience: • Part I is an informal introduction for new users. • Part II documents the SQL query language environment,0 码力 | 1582 页 | 12.19 MB | 1 年前3 PostgreSQL 8.1.11 Documentation.............................................................................................xliv I. Tutorial.......................................................................................... ..............................................................................................717 I. SQL Commands...................................................................................... a different class of users, or at users in different stages of their PostgreSQL experience: • Part I is an informal introduction for new users. • Part II documents the SQL query language environment,0 码力 | 1582 页 | 12.19 MB | 1 年前3
共 44 条
- 1
- 2
- 3
- 4
- 5













