01.02.02.DeepSeek：环境搭建篇（数据库插件 PGVector 向量数据库）
操作流程1、下载安装2、配置3、测试下载安装PGVector:向量数据库扩展cd/usr/local/softwaregitclone https://github.com/pgvector/pgvector.gitcd/usr/local/software/pgvectormake-j$(nproc)PG_CONFIG/usr/local/software/postgresql/data/pgsql/bin/pg_configmakeinstall-j$(nproc)PG_CONFIG/usr/local/software/postgresql/data/pgsql/bin/pg_configchmod0777-R/usr/local/software/pgvectorchown$USER:$USER-R/usr/local/software/pgvector配置修改数据库配置cat/usr/local/software/postgresql/data/pgdata/postgresql.confEOF shared_preload_libraries vector EOF# 重启数据库sudo-upostgres /usr/local/software/postgresql/data/pgsql/bin/pg_ctl restart-D/usr/local/software/postgresql/data/pgdata-l/usr/local/software/postgresql/data/pglog/logfile连接数据库# 用户anythingllm 连接数据库 密码QwE123*~*psql-h127.0.0.1-Uanythingllm-p5432-dvector_db-W数据库操作-- 安装扩展vectorCREATEEXTENSIONIFNOTEXISTSvector;-- 创建数据表结构设计CREATETABLEIFNOTEXISTSanythingllm_vectors(id UUIDPRIMARYKEY,namespaceTEXT,embedding vector(384),-- 维度根据嵌入模型调整metadata JSONB,created_atTIMESTAMPDEFAULTCURRENT_TIMESTAMP);-- 索引优-- 创建HNSW索引提升搜索性能CREATEINDEXONanythingllm_vectorsUSINGhnsw(embedding vector_cosine_ops)WITH(m16,ef_construction64);-- 命名空间索引CREATEINDEXONanythingllm_vectors(namespace);-- 安全配置GRANTALLONanythingllm_vectorsTOanythingllm;配置环境变量cat/etc/profileEOF #set pgvector environment PGVECTOR/usr/local/software/pgvector VECTOR_DBpgvector PGVECTOR_CONNECTION_STRINGpostgresql://anythingllm:QwE123*~*localhost:5432/vector_db PGVECTOR_TABLE_NAMEanythingllm_vectors PATH$PGVECTOR:$VECTOR_DB:$PGVECTOR_CONNECTION_STRING:$PGVECTOR_TABLE_NAME:$PATH: export PGVECTOR VECTOR_DB PGVECTOR_CONNECTION_STRING PGVECTOR_TABLE_NAME PATH EOFsource/etc/profile测试数据库操作-- 监控指标-- 监控查询性能SELECTnamespace,COUNT(*)asvector_count,AVG(LENGTH(metadata::text))asavg_metadata_sizeFROManythingllm_vectorsGROUPBYnamespace;-- 索引使用情况SELECT*FROMpg_stat_all_indexesWHEREschemanamepublicANDrelnameanythingllm_vectors;
