pgvector:Postgres 的开源向量相似度搜索

上传者: 42134094 | 上传时间: 2022-07-01 09:46:20 | 文件大小: 45KB | 文件类型: ZIP
向量 Postgres 的开源向量相似度搜索 CREATE TABLE table (column vector( 3 )); CREATE INDEX ON table USING ivfflat (column); SELECT * FROM table ORDER BY column < - > ' [1,2,3] ' LIMIT 5 ; 支持 L2 距离、内积和余弦距离 安装 编译安装扩展(支持 Postgres 9.6+) git clone --branch v0.1.7 https://github.com/ankane/pgvector.git cd pgvector make make install # may need sudo 然后将其加载到要使用它的数据库中 CREATE EXTENSION vector; 您还可以使用 、 或安装它 入门 创建一个 3

文件下载

资源详情

[{"title":"( 50 个子文件 45KB ) pgvector:Postgres 的开源向量相似度搜索","children":[{"title":"pgvector-master","children":[{"title":".gitignore <span style='color:#111;'> 74B </span>","children":null,"spread":false},{"title":"Dockerfile <span style='color:#111;'> 479B </span>","children":null,"spread":false},{"title":"Makefile <span style='color:#111;'> 1.46KB </span>","children":null,"spread":false},{"title":"sql","children":[{"title":"vector.sql <span style='color:#111;'> 7.44KB </span>","children":null,"spread":false},{"title":"vector--0.1.1--0.1.3.sql <span style='color:#111;'> 153B </span>","children":null,"spread":false},{"title":"vector--0.1.4--0.1.5.sql <span style='color:#111;'> 153B </span>","children":null,"spread":false},{"title":"vector--0.1.0--0.1.1.sql <span style='color:#111;'> 2.00KB </span>","children":null,"spread":false},{"title":"vector--0.1.5--0.1.6.sql <span style='color:#111;'> 153B </span>","children":null,"spread":false},{"title":"vector--0.1.3--0.1.4.sql <span style='color:#111;'> 153B </span>","children":null,"spread":false},{"title":"vector--0.1.7--0.1.8.sql <span style='color:#111;'> 396B </span>","children":null,"spread":false},{"title":"vector--0.1.6--0.1.7.sql <span style='color:#111;'> 403B </span>","children":null,"spread":false}],"spread":true},{"title":"src","children":[{"title":"ivfutils.c <span style='color:#111;'> 3.57KB </span>","children":null,"spread":false},{"title":"ivfinsert.c <span style='color:#111;'> 3.96KB </span>","children":null,"spread":false},{"title":"vector.h <span style='color:#111;'> 891B </span>","children":null,"spread":false},{"title":"vector.c <span style='color:#111;'> 13.97KB </span>","children":null,"spread":false},{"title":"ivfkmeans.c <span style='color:#111;'> 11.54KB </span>","children":null,"spread":false},{"title":"ivfbuild.c <span style='color:#111;'> 13.93KB </span>","children":null,"spread":false},{"title":"ivfvacuum.c <span style='color:#111;'> 3.65KB </span>","children":null,"spread":false},{"title":"ivfflat.c <span style='color:#111;'> 5.01KB </span>","children":null,"spread":false},{"title":"ivfscan.c <span style='color:#111;'> 8.46KB </span>","children":null,"spread":false},{"title":"ivfflat.h <span style='color:#111;'> 5.42KB </span>","children":null,"spread":false}],"spread":true},{"title":".dockerignore <span style='color:#111;'> 81B </span>","children":null,"spread":false},{"title":"LICENSE <span style='color:#111;'> 1.08KB </span>","children":null,"spread":false},{"title":"CHANGELOG.md <span style='color:#111;'> 650B </span>","children":null,"spread":false},{"title":".github","children":[{"title":"workflows","children":[{"title":"build.yml <span style='color:#111;'> 1.33KB </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"vector.control <span style='color:#111;'> 135B </span>","children":null,"spread":false},{"title":"README.md <span style='color:#111;'> 6.84KB </span>","children":null,"spread":false},{"title":"META.json <span style='color:#111;'> 1.07KB </span>","children":null,"spread":false},{"title":"test","children":[{"title":"t","children":[{"title":"001_wal.pl <span style='color:#111;'> 2.83KB </span>","children":null,"spread":false}],"spread":false},{"title":"sql","children":[{"title":"btree.sql <span style='color:#111;'> 325B </span>","children":null,"spread":false},{"title":"ivfflat_cosine.sql <span style='color:#111;'> 438B </span>","children":null,"spread":false},{"title":"input.sql <span style='color:#111;'> 394B </span>","children":null,"spread":false},{"title":"cast.sql <span style='color:#111;'> 481B </span>","children":null,"spread":false},{"title":"ivfflat_ip.sql <span style='color:#111;'> 434B </span>","children":null,"spread":false},{"title":"functions.sql <span style='color:#111;'> 548B </span>","children":null,"spread":false},{"title":"ivfflat_options.sql <span style='color:#111;'> 286B </span>","children":null,"spread":false},{"title":"copy.sql <span style='color:#111;'> 377B </span>","children":null,"spread":false},{"title":"ivfflat_unlogged.sql <span style='color:#111;'> 332B </span>","children":null,"spread":false},{"title":"ivfflat_l2.sql <span style='color:#111;'> 444B </span>","children":null,"spread":false}],"spread":false},{"title":"expected","children":[{"title":"functions.out <span style='color:#111;'> 1.02KB </span>","children":null,"spread":false},{"title":"cast.out <span style='color:#111;'> 933B </span>","children":null,"spread":false},{"title":"ivfflat_options.out <span style='color:#111;'> 533B </span>","children":null,"spread":false},{"title":"ivfflat_ip.out <span style='color:#111;'> 518B </span>","children":null,"spread":false},{"title":"ivfflat_l2.out <span style='color:#111;'> 560B </span>","children":null,"spread":false},{"title":"ivfflat_unlogged.out <span style='color:#111;'> 386B </span>","children":null,"spread":false},{"title":"ivfflat_cosine.out <span style='color:#111;'> 513B </span>","children":null,"spread":false},{"title":"input.out <span style='color:#111;'> 1.44KB </span>","children":null,"spread":false},{"title":"btree.out <span style='color:#111;'> 398B </span>","children":null,"spread":false},{"title":"copy.out <span style='color:#111;'> 431B </span>","children":null,"spread":false}],"spread":false}],"spread":true},{"title":".editorconfig <span style='color:#111;'> 74B </span>","children":null,"spread":false}],"spread":false}],"spread":true}]

评论信息

免责申明

【只为小站】的资源来自网友分享,仅供学习研究,请务必在下载后24小时内给予删除,不得用于其他任何用途,否则后果自负。基于互联网的特殊性,【只为小站】 无法对用户传输的作品、信息、内容的权属或合法性、合规性、真实性、科学性、完整权、有效性等进行实质审查;无论 【只为小站】 经营者是否已进行审查,用户均应自行承担因其传输的作品、信息、内容而可能或已经产生的侵权或权属纠纷等法律责任。
本站所有资源不代表本站的观点或立场,基于网友分享,根据中国法律《信息网络传播权保护条例》第二十二条之规定,若资源存在侵权或相关问题请联系本站客服人员,zhiweidada#qq.com,请把#换成@,本站将给予最大的支持与配合,做到及时反馈和处理。关于更多版权及免责申明参见 版权及免责申明