 PostgresChina 2018 张启程 为什么我们抛弃MongoDB和MySQL,选择PgSQL主要业务场景 • IM工具+SCRM系统(高并发、低延迟、稳定) • 大量客户需要私有化云服务器部署(云更新) • 需求变更频繁,不适合关系型数据库 2018年PostgreSQL中国技术大会 目前服务器架构 2018年PostgreSQL中国技术大会 MySQL应用史 • 最开始做的站群系统WEB端使用MySQL: • copy简单快速,批量复制,替换修改简单; • 每个网站一个库,单体数据量小,数据类型固定; MongoDB存储,减轻MySQL负担; • 这种方式虽然可以暂时解决问题,我们自己用也没有任何 问题,可以结合各自数据库优点,发挥性能。但是我们有 很多客户是需要私有化部署数据库,让每家客户都接受这 种方式,会为甲方增加很多服务器以及运维成本,可能客 户数据量很少,也需要使用双数据库,更新运维都比较麻 烦。 2018年PostgreSQL中国技术大会 PgSQL≈MySQL+MongoDB • 个人认为,PgSQL结合了MySQL关系型数据库事务处理能力0 码力 | 9 页 | 563.82 KB | 1 年前3 PostgresChina 2018 张启程 为什么我们抛弃MongoDB和MySQL,选择PgSQL主要业务场景 • IM工具+SCRM系统(高并发、低延迟、稳定) • 大量客户需要私有化云服务器部署(云更新) • 需求变更频繁,不适合关系型数据库 2018年PostgreSQL中国技术大会 目前服务器架构 2018年PostgreSQL中国技术大会 MySQL应用史 • 最开始做的站群系统WEB端使用MySQL: • copy简单快速,批量复制,替换修改简单; • 每个网站一个库,单体数据量小,数据类型固定; MongoDB存储,减轻MySQL负担; • 这种方式虽然可以暂时解决问题,我们自己用也没有任何 问题,可以结合各自数据库优点,发挥性能。但是我们有 很多客户是需要私有化部署数据库,让每家客户都接受这 种方式,会为甲方增加很多服务器以及运维成本,可能客 户数据量很少,也需要使用双数据库,更新运维都比较麻 烦。 2018年PostgreSQL中国技术大会 PgSQL≈MySQL+MongoDB • 个人认为,PgSQL结合了MySQL关系型数据库事务处理能力0 码力 | 9 页 | 563.82 KB | 1 年前3
 阿里云 AnalyticDB for PostgreSQL
- 打造更简单易用的Cloud SQL Data Warehouse场景应用: 1、Web App把图片或者视频等非结构化数据 通过特征提取服务,提取特征向量,并写入 AnalyticDB for PG的向量表。 2、Web App检索的时,把非结构化数据通过 特征提取服务接口提取出向量,同时调用 AnalyticDB for PG的查询分析接口做查询。 特点: • 易用,结构化和非结构化数据关联查询。 • 准确性高,阿里自研向量检索算法。 Web APP AnalyticDB0 码力 | 22 页 | 2.98 MB | 1 年前3 阿里云 AnalyticDB for PostgreSQL
- 打造更简单易用的Cloud SQL Data Warehouse场景应用: 1、Web App把图片或者视频等非结构化数据 通过特征提取服务,提取特征向量,并写入 AnalyticDB for PG的向量表。 2、Web App检索的时,把非结构化数据通过 特征提取服务接口提取出向量,同时调用 AnalyticDB for PG的查询分析接口做查询。 特点: • 易用,结构化和非结构化数据关联查询。 • 准确性高,阿里自研向量检索算法。 Web APP AnalyticDB0 码力 | 22 页 | 2.98 MB | 1 年前3
 PostgreSQL 8.2 DocumentationSQL language interpreter to POSTGRES. Under a new name, Postgres95 was subsequently released to the web to find its own way in the world as an open- source descendant of the original POSTGRES Berkeley code asked questions. READMEs README files are available for most contributed packages. Web Site The PostgreSQL web site5 carries details on the latest release and other information to make your work or answered, to share experiences with other users, and to contact the developers. Consult the PostgreSQL web site for details. Yourself! PostgreSQL is an open-source project. As such, it depends on the user0 码力 | 1762 页 | 5.43 MB | 1 年前3 PostgreSQL 8.2 DocumentationSQL language interpreter to POSTGRES. Under a new name, Postgres95 was subsequently released to the web to find its own way in the world as an open- source descendant of the original POSTGRES Berkeley code asked questions. READMEs README files are available for most contributed packages. Web Site The PostgreSQL web site5 carries details on the latest release and other information to make your work or answered, to share experiences with other users, and to contact the developers. Consult the PostgreSQL web site for details. Yourself! PostgreSQL is an open-source project. As such, it depends on the user0 码力 | 1762 页 | 5.43 MB | 1 年前3
 PostgreSQL 8.2 DocumentationSQL language interpreter to POSTGRES. Under a new name, Postgres95 was subsequently released to the web to find its own way in the world as an open- source descendant of the original POSTGRES Berkeley code asked questions. READMEs README files are available for most contributed packages. Web Site The PostgreSQL web site5 carries details on the latest release and other information to make your work or answered, to share experiences with other users, and to contact the developers. Consult the PostgreSQL web site for details. Yourself! PostgreSQL is an open-source project. As such, it depends on the user0 码力 | 1748 页 | 13.12 MB | 1 年前3 PostgreSQL 8.2 DocumentationSQL language interpreter to POSTGRES. Under a new name, Postgres95 was subsequently released to the web to find its own way in the world as an open- source descendant of the original POSTGRES Berkeley code asked questions. READMEs README files are available for most contributed packages. Web Site The PostgreSQL web site5 carries details on the latest release and other information to make your work or answered, to share experiences with other users, and to contact the developers. Consult the PostgreSQL web site for details. Yourself! PostgreSQL is an open-source project. As such, it depends on the user0 码力 | 1748 页 | 13.12 MB | 1 年前3
 PostgreSQL 8.0 DocumentationSQL language interpreter to POSTGRES. Under a new name, Postgres95 was subsequently released to the web to find its own way in the world as an open- source descendant of the original POSTGRES Berkeley code asked questions. READMEs README files are available for most contributed packages. Web Site The PostgreSQL web site5 carries details on the latest release and other information to make your work or answered, to share experiences with other users, and to contact the developers. Consult the PostgreSQL web site for details. Yourself! PostgreSQL is an open-source project. As such, it depends on the user0 码力 | 1422 页 | 9.92 MB | 1 年前3 PostgreSQL 8.0 DocumentationSQL language interpreter to POSTGRES. Under a new name, Postgres95 was subsequently released to the web to find its own way in the world as an open- source descendant of the original POSTGRES Berkeley code asked questions. READMEs README files are available for most contributed packages. Web Site The PostgreSQL web site5 carries details on the latest release and other information to make your work or answered, to share experiences with other users, and to contact the developers. Consult the PostgreSQL web site for details. Yourself! PostgreSQL is an open-source project. As such, it depends on the user0 码力 | 1422 页 | 9.92 MB | 1 年前3
 PostgreSQL 8.0 DocumentationSQL language interpreter to POSTGRES. Under a new name, Postgres95 was subsequently released to the web to find its own way in the world as an open- source descendant of the original POSTGRES Berkeley code asked questions. READMEs README files are available for most contributed packages. Web Site The PostgreSQL web site5 carries details on the latest release and other information to make your work or answered, to share experiences with other users, and to contact the developers. Consult the PostgreSQL web site for details. Yourself! PostgreSQL is an open-source project. As such, it depends on the user0 码力 | 1332 页 | 9.76 MB | 1 年前3 PostgreSQL 8.0 DocumentationSQL language interpreter to POSTGRES. Under a new name, Postgres95 was subsequently released to the web to find its own way in the world as an open- source descendant of the original POSTGRES Berkeley code asked questions. READMEs README files are available for most contributed packages. Web Site The PostgreSQL web site5 carries details on the latest release and other information to make your work or answered, to share experiences with other users, and to contact the developers. Consult the PostgreSQL web site for details. Yourself! PostgreSQL is an open-source project. As such, it depends on the user0 码力 | 1332 页 | 9.76 MB | 1 年前3
 PostgreSQL 8.1.11 DocumentationSQL language interpreter to POSTGRES. Under a new name, Postgres95 was subsequently released to the web to find its own way in the world as an open- source descendant of the original POSTGRES Berkeley code asked questions. READMEs README files are available for most contributed packages. Web Site The PostgreSQL web site5 carries details on the latest release and other information to make your work or answered, to share experiences with other users, and to contact the developers. Consult the PostgreSQL web site for details. Yourself! PostgreSQL is an open-source project. As such, it depends on the user0 码力 | 1582 页 | 12.19 MB | 1 年前3 PostgreSQL 8.1.11 DocumentationSQL language interpreter to POSTGRES. Under a new name, Postgres95 was subsequently released to the web to find its own way in the world as an open- source descendant of the original POSTGRES Berkeley code asked questions. READMEs README files are available for most contributed packages. Web Site The PostgreSQL web site5 carries details on the latest release and other information to make your work or answered, to share experiences with other users, and to contact the developers. Consult the PostgreSQL web site for details. Yourself! PostgreSQL is an open-source project. As such, it depends on the user0 码力 | 1582 页 | 12.19 MB | 1 年前3
 PostgreSQL 8.1 DocumentationSQL language interpreter to POSTGRES. Under a new name, Postgres95 was subsequently released to the web to find its own way in the world as an open- source descendant of the original POSTGRES Berkeley code asked questions. READMEs README files are available for most contributed packages. Web Site The PostgreSQL web site5 carries details on the latest release and other information to make your work or answered, to share experiences with other users, and to contact the developers. Consult the PostgreSQL web site for details. Yourself! PostgreSQL is an open-source project. As such, it depends on the user0 码力 | 1548 页 | 11.54 MB | 1 年前3 PostgreSQL 8.1 DocumentationSQL language interpreter to POSTGRES. Under a new name, Postgres95 was subsequently released to the web to find its own way in the world as an open- source descendant of the original POSTGRES Berkeley code asked questions. READMEs README files are available for most contributed packages. Web Site The PostgreSQL web site5 carries details on the latest release and other information to make your work or answered, to share experiences with other users, and to contact the developers. Consult the PostgreSQL web site for details. Yourself! PostgreSQL is an open-source project. As such, it depends on the user0 码力 | 1548 页 | 11.54 MB | 1 年前3
 PostgreSQL 8.3 DocumentationSQL language interpreter to POSTGRES. Under a new name, Postgres95 was subsequently released to the web to find its own way in the world as an open- source descendant of the original POSTGRES Berkeley code FAQs The FAQ list contains continuously updated answers to frequently asked questions. Web Site The PostgreSQL web site5 carries details on the latest release and other information to make your work or answered, to share experiences with other users, and to contact the developers. Consult the PostgreSQL web site for details. Yourself! PostgreSQL is an open-source project. As such, it depends on the user0 码力 | 2143 页 | 4.58 MB | 1 年前3 PostgreSQL 8.3 DocumentationSQL language interpreter to POSTGRES. Under a new name, Postgres95 was subsequently released to the web to find its own way in the world as an open- source descendant of the original POSTGRES Berkeley code FAQs The FAQ list contains continuously updated answers to frequently asked questions. Web Site The PostgreSQL web site5 carries details on the latest release and other information to make your work or answered, to share experiences with other users, and to contact the developers. Consult the PostgreSQL web site for details. Yourself! PostgreSQL is an open-source project. As such, it depends on the user0 码力 | 2143 页 | 4.58 MB | 1 年前3
 PostgreSQL 8.3 DocumentationSQL language interpreter to POSTGRES. Under a new name, Postgres95 was subsequently released to the web to find its own way in the world as an open- source descendant of the original POSTGRES Berkeley code FAQs The FAQ list contains continuously updated answers to frequently asked questions. Web Site The PostgreSQL web site5 carries details on the latest release and other information to make your work or answered, to share experiences with other users, and to contact the developers. Consult the PostgreSQL web site for details. Yourself! PostgreSQL is an open-source project. As such, it depends on the user0 码力 | 2015 页 | 4.54 MB | 1 年前3 PostgreSQL 8.3 DocumentationSQL language interpreter to POSTGRES. Under a new name, Postgres95 was subsequently released to the web to find its own way in the world as an open- source descendant of the original POSTGRES Berkeley code FAQs The FAQ list contains continuously updated answers to frequently asked questions. Web Site The PostgreSQL web site5 carries details on the latest release and other information to make your work or answered, to share experiences with other users, and to contact the developers. Consult the PostgreSQL web site for details. Yourself! PostgreSQL is an open-source project. As such, it depends on the user0 码力 | 2015 页 | 4.54 MB | 1 年前3
共 42 条
- 1
- 2
- 3
- 4
- 5













