--- title: "What is pgvector?" source_name: "Databricks" original_url: "https://www.databricks.com/blog/what-is-pgvector" canonical_url: "https://www.traeai.com/articles/cd795154-49c9-46a9-90be-ce1372b1cfc5" content_type: "article" language: "英文" score: 5.5 tags: ["pgvector","向量数据库","Databricks","技术介绍"] published_at: "2026-04-17T06:59:30+00:00" created_at: "2026-04-18T03:01:24.565761+00:00" --- # What is pgvector? Canonical URL: https://www.traeai.com/articles/cd795154-49c9-46a9-90be-ce1372b1cfc5 Original source: https://www.databricks.com/blog/what-is-pgvector ## Summary 文章标题为“What is pgvector?”但正文内容缺失，仅包含Databricks网站导航菜单和产品链接，无实质技术信息。 ## Key Takeaways - 文章未提供pgvector的技术定义、原理或使用场景 - 正文内容为空，仅有网站导航和营销链接 - 无法从中获取关于pgvector或向量数据库的有效信息 ## Content Title: What is pgvector? URL Source: http://www.databricks.com/blog/what-is-pgvector Published Time: Fri, 04/17/2026 - 06:59 Markdown Content: # What is pgvector? | Databricks [Skip to main content](http://www.databricks.com/blog/what-is-pgvector#main) [![Image 1](blob:http://localhost/c3d26385bd032c882a09c45135533626)](http://www.databricks.com/) [![Image 2](blob:http://localhost/c3d26385bd032c882a09c45135533626)](http://www.databricks.com/) * Why Databricks * * Discover * [For App Developers](http://www.databricks.com/developers) * [For Executives](http://www.databricks.com/why-databricks/executives) * [For Startups](http://www.databricks.com/product/startups) * [Lakehouse Architecture](http://www.databricks.com/product/data-lakehouse) * [Databricks AI Research](http://www.databricks.com/research/databricks-ai-research) * Customers * [Customer Stories](http://www.databricks.com/customers) * Partners * [Partner Overview Explore the Databricks partner ecosystem](http://www.databricks.com/partners) * [Partner Program Explore benefits, tiers and how to become a partner](http://www.databricks.com/partners/partner-program) * [Find a Partner Discover Databricks partners for your needs](http://www.databricks.com/partners/partner-directory) * [Partner Spotlight Featured partner announcements](http://www.databricks.com/partners/partner-spotlight) * [Cloud Providers Databricks on AWS, Azure and GCP](http://www.databricks.com/partners/cloud-partners) * [Partner Solutions Find custom industry and migration solutions](http://www.databricks.com/partners/consulting-and-si/partner-solutions) * Product * * Databricks Platform * [Platform Overview A unified platform for data, analytics and AI](http://www.databricks.com/product/data-intelligence-platform) * [Sharing An open, secure, zero-copy sharing for all data](http://www.databricks.com/product/delta-sharing) * [Governance Unified governance for all data, analytics and AI assets](http://www.databricks.com/product/unity-catalog) * [Artificial Intelligence Build and deploy ML and GenAI applications](http://www.databricks.com/product/artificial-intelligence) * [Business Intelligence Intelligent analytics for real-world data](https://www.databricks.com/product/business-intelligence) * [Database Postgres for data apps and AI agents](http://www.databricks.com/product/lakebase) * [Data Management Data reliability, security and performance](http://www.databricks.com/product/delta-lake-on-databricks) * [Data Warehousing Serverless data warehouse for SQL analytics](http://www.databricks.com/product/databricks-sql) * [Data Engineering ETL and orchestration for batch and streaming data](http://www.databricks.com/product/data-engineering) * [Data Science Collaborative data science at scale](http://www.databricks.com/product/data-science) * [Application Development Quickly build secure data and AI apps](http://www.databricks.com/product/databricks-apps) * [Security Open agentic SIEM built for the AI era](http://www.databricks.com/product/lakewatch) * Integrations and Data * [Marketplace Open marketplace for data, analytics and AI](http://www.databricks.com/product/marketplace) * [IDE Integrations Build on the Lakehouse in your favorite IDE](http://www.databricks.com/product/data-science/ide-integrations) * [Partner Connect Discover and integrate with the Databricks ecosystem](http://www.databricks.com/partnerconnect) * Pricing * [Databricks Pricing Explore product pricing, DBUs and more](http://www.databricks.com/product/pricing) * [Cost Calculator Estimate your compute costs on any cloud](http://www.databricks.com/product/pricing/product-pricing/instance-types) * Open Source * [Open Source Technologies Learn more about the innovations behind the platform](http://www.databricks.com/product/open-source) * Solutions * * Databricks for Industries * [Communications](http://www.databricks.com/solutions/industries/communications) * [Financial Services](http://www.databricks.com/solutions/industries/financial-services) * [Healthcare & Life Sciences](http://www.databricks.com/solutions/industries/healthcare-and-life-sciences) * [Manufacturing](http://www.databricks.com/solutions/industries/manufacturing-industry-solutions) * [Media and Entertainment](http://www.databricks.com/solutions/industries/media-and-entertainment) * [Public Sector](http://www.databricks.com/solutions/industries/public-sector) * [Retail](http://www.databricks.com/solutions/industries/retail-industry-solutions) * [See All Industries](http://www.databricks.com/solutions) * Cross Industry Solutions * [AI Agents](http://www.databricks.com/solutions/ai-agents) * [Cybersecurity](http://www.databricks.com/solutions/industries/cybersecurity) * [Marketing](http://www.databricks.com/solutions/industries/marketing) * Migration & Deployment * [Data Migration](http://www.databricks.com/solutions/migration) * [Professional Services](http://www.databricks.com/professional-services) * Solution Accelerators * [Explore Accelerators Move faster toward outcomes that matter](http://www.databricks.com/solutions/accelerators) * Resources * * Learning * [Training Discover curriculum tailored to your needs](https://www.databricks.com/learn/training/home) * [Databricks Academy Sign in to the Databricks learning platform](https://www.databricks.com/learn/training/login) * [Certification Gain recognition and differentiation](https://www.databricks.com/learn/training/certification) * [Free Edition Learn professional Data and AI tools for free](http://www.databricks.com/learn/free-edition) * [University Alliance Want to teach Databricks? See how.](http://www.databricks.com/university) * Events * [Data + AI Summit](https://www.databricks.com/dataaisummit) * [Data + AI World Tour](http://www.databricks.com/dataaisummit/worldtour) * [AI Days](https://www.databricks.com/ai-days) * [Event Calendar](http://www.databricks.com/events) * Blog and Podcasts * [Databricks Blog Explore news, product announcements, and more](http://www.databricks.com/blog) * [Databricks AI R&D Blog Explore our AI research and engineering work](http://www.databricks.com/blog/category/ai) * [Data Brew Podcast Let’s talk data!](http://www.databricks.com/discover/data-brew) * [Champions of Data + AI Podcast Insights from data leaders powering innovation](http://www.databricks.com/discover/champions-of-data-and-ai) * Get Help * [Customer Support](https://www.databricks.com/support) * [Documentation](https://www.databricks.com/databricks-documentation) * [Community](https://community.databricks.com/s/) * Dive Deep * [Resource Center](http://www.databricks.com/resources) * [Demo Center](http://www.databricks.com/resources/demos) * [Architecture Center](http://www.databricks.com/resources/architectures) * About * * Company * [Who We Are](http://www.databricks.com/company/about-us) * [Our Team](http://www.databricks.com/company/leadership-team) * [Databricks Ventures](http://www.databricks.com/databricks-ventures) * [Contact Us](http://www.databricks.com/company/contact) * Careers * [Working at Databricks](http://www.databricks.com/company/careers) * [Open Jobs](http://www.databricks.com/company/careers/open-positions) * Press * [Awards and Recognition](http://www.databricks.com/company/awards-and-recognition) * [Newsroom](http://www.databricks.com/company/newsroom) * Security and Trust * [Security and Trust](http://www.databricks.com/trust) * DATA + AI SUMMIT [![Image 3: Data+ai summit promo](https://www.databricks.com/sites/default/files/2026-03/dais26-nav-promo-240x96-2x.svg) JUNE 15–18|SAN FRANCISCO Last chance to save 50% — ends April 30. Register](http://www.databricks.com/dataaisummit?itm_source=www&itm_category=home&itm_page=home&itm_location=navigation&itm_component=navigation&itm_offer=dataaisummit) * [Login](https://login.databricks.com/?dbx_source=www&itm=main-cta-login&l=en-EN) * [Contact Us](http://www.databricks.com/company/contact) * [Try Databricks](https://www.databricks.com/signup?dbx_source=www&itm_data=dbx-web-nav&l=en-EN&itm_source=www&itm_category=blog&itm_page=what-is-pgvector&itm_location=nav&itm_component=menu-area&itm_offer=signup) 1. [Blog](http://www.databricks.com/blog) 2. / [Data + AI Foundations](http://www.databricks.com/blog/category/data-ai-foundations) 3. / Topic * * * Contents in this story How pgvector works * [How pgvector works](http://www.databricks.com/blog/what-is-pgvector#section-1) * [Key features of pgvector](http://www.databricks.com/blog/what-is-pgvector#section-2) * [Common use cases for pgvector](http://www.databricks.com/blog/what-is-pgvector#section-3) * [pgvector vs. dedicated vector databases: when to use each](http://www.databricks.com/blog/what-is-pgvector#section-4) * [Limitations and scaling considerations](http://www.databricks.com/blog/what-is-pgvector#section-5) * [Getting started with pgvector](http://www.databricks.com/blog/what-is-pgvector#section-6) * [pgvector and the modern AI data stack](http://www.databricks.com/blog/what-is-pgvector#section-7) * [Frequently asked questions](http://www.databricks.com/blog/what-is-pgvector#section-8) * [Choosing the right vector search approach](http://www.databricks.com/blog/what-is-pgvector#section-9) # What is pgvector? ## A PostgreSQL extension for storing and searching vector embeddings natively within your existing database. ![Image 4: 4 Personas AI Agents 6](https://www.databricks.com/sites/default/files/2026-01/4-personas-ai-agents-6-2x-og.png?v=1769105719) [Data + AI Foundations](http://www.databricks.com/blog/category/data-ai-foundations)8 min read by [Databricks Staff](http://www.databricks.com/blog/author/databricks-staff) Share this post * [](https://www.linkedin.com/shareArticle?mini=true&url=https://www.databricks.com/blog/what-is-pgvector&summary=&source=) * [](https://twitter.com/intent/tweet?text=https://www.databricks.com/blog/what-is-pgvector) * [](https://www.facebook.com/sharer/sharer.php?u=https://www.databricks.com/blog/what-is-pgvector) Keep up with us Subscribe #### Summary * pgvector is a PostgreSQL extension that enables vector storage and similarity search directly within Postgres, eliminating the need for a separate vector database for most AI use cases like semantic search, RAG, and recommendations. * It supports multiple distance metrics, two index types (HNSW and IVFFlat), filtered search, and hybrid search, all natively within SQL, making it operationally simple for teams already on Postgres. * pgvector handles millions of vectors well, but performance degrades at very high scale; pgvectorscale and dedicated vector databases like Pinecone or Weaviate are the natural next steps as workloads grow. pgvector is an open-source [PostgreSQL](https://www.databricks.com/blog/what-is-postgresql-database) extension that adds the ability to store, index and search vector embeddings (numerical representations of data). It brings vector data and similarity search into the same system that holds application data, making it possible to power semantic search, recommendations and [retrieval-augmented generation](https://www.databricks.com/blog/what-is-retrieval-augmented-generation) (RAG) without relying on an external [vector database](https://www.databricks.com/blog/what-is-vector-database). pgvector extends Postgres to support these AI-driven use cases. Many modern AI applications depend on retrieving semantically similar data, not just exact matches. pgvector allows teams to perform this type of retrieval at runtime within their existing Postgres stack. For example, applications often need to retrieve content that is contextually similar to a query, even if the wording is different. This approach is often referred to as cosine similarity, nearest neighbor search or embedding-based search. This article provides a high-level, educational overview of pgvector rather than detailed implementation guidance. ## How pgvector works pgvector adds a new data type to Postgres called `vector`. It allows embeddings, numerical representations of text, images or other content to be stored alongside relational data without requiring a separate system. These embeddings are typically generated by [machine learning models](https://www.databricks.com/blog/what-are-machine-learning-models) that convert content such as text or images into numerical form. At a high level, the process is simple. Embeddings are stored in the database. When a query is received, a query embedding is generated from the input, and pgvector returns the records whose vectors are most similar, or closest in meaning to that query. Instead of matching keywords, results are retrieved based on meaning. pgvector determines similarity using distance metrics: * L2 (Euclidean distance): measures the distance between vectors, where smaller values indicate greater similarity * Cosine similarity: measures how closely vectors point in the same direction, which often reflects similarity in meaning * Inner product: measures alignment between vectors and is often used with normalized embeddings ## Key features of pgvector pgvector includes several features that make vector search practical within Postgres. * **Indexing:**Two index types are supported: HNSW and IVFFlat. HNSW prioritizes query speed and builds a graph structure in memory, but requires more memory. IVFFlat is more memory-efficient and partitions vectors into clusters using a training step, but queries may be slower. * **Distance metrics:** L2, cosine similarity and inner product cover most embedding-based use cases. Hamming distance supports binary vectors, and Jaccard distance supports sparse vectors in more specialized scenarios. * **Filtered search:** Vector similarity can be combined with standard relational filters. For example, results can include the most semantically similar products that are also in stock, within a price range or in a specific category. * **Hybrid search:**pgvector can be paired with Postgres full-text search to blend keyword and semantic search. This allows results to be both contextually relevant and textually precise in a single query. * **Additional data types:** Options such as `halfvec`, `sparsevec` and `bit` types help reduce memory usage when working with large embedding datasets. ## Common use cases for pgvector pgvector is widely used to power AI-driven application features: ### Semantic search and RAG Applications can retrieve documents or content based on meaning rather than keywords. This is a core component of retrieval-augmented generation (RAG), where [large language models](https://www.databricks.com/blog/what-are-large-language-models) use retrieved context to generate accurate, relevant responses. Because pgvector runs similarity search directly within Postgres, this retrieval can happen in real time without requiring a separate system. ### Recommendation systems Items can be matched to past behavior or preferences to support recommendations. This pattern is commonly used for product recommendations, content discovery and personalization in applications. pgvector makes it efficient to identify related items based on patterns in user behavior or content. ### Image similarity Image embeddings can be stored and compared to quickly find visually similar images. This is widely used in media platforms, e-commerce and creative tools. Storing these embeddings alongside application data makes it easier to run similarity searches without additional infrastructure. ### Anomaly detection Outliers can be identified by finding data points that are distant from typical patterns in vector space. This is useful for fraud detection, monitoring and quality control. pgvector enables this by making it easy to compare vectors and detect deviations. ### Deduplication Duplicate or near-duplicate content can be identified, even when it is expressed differently or formatted in different ways. This is important for content management, search quality and data hygiene. Similarity-based comparison makes it possible to detect duplicates beyond exact matches. ## pgvector vs. dedicated vector databases: when to use each As vector search becomes part of more applications, teams often face a practical decision: should vector search stay within Postgres, or is a dedicated vector database needed? The answer depends on scale, performance requirements and operational complexity. The differences can be summarized across key dimensions: **Tool****Operational Complexity****Scalability Ceiling****Hybrid Query Support****Cost****Ecosystem Maturity** **pgvector****Lowest** (Existing DB)High (~100M+ vectors)**Best** (Native SQL Joins)Lowest (Included)High (Postgres ecosystem) **Pinecone**Low (Serverless/SaaS)**Highest** (Billions+)Moderate (Metadata only)High (Usage-based)High (AI-specific) **Weaviate**Moderate (Multi-modal)Very High High (GraphQL/Vector)Moderate High (Open-source) **Qdrant**Moderate (Rust-based)Very High High (Filtering-heavy)Moderate Growing Fast pgvector is the natural starting point for teams already using Postgres and operating below the scale ceiling. It works well when vector search is part of an existing application workflow and data volumes or query demands remain manageable. Dedicated vector databases become more relevant when query volume, recall requirements or multi-tenant workloads push beyond what Postgres can efficiently support. ### pgvectorscale pgvectorscale is designed for teams that want to extend how far they can go with pgvector before adopting a dedicated vector database. It addresses the performance and scalability challenges that arise as data volumes and query demands increase, particularly around indexing speed and query latency. By improving how pgvector performs at larger scales, it allows teams to continue using Postgres for longer without re-architecting their systems. This makes it a practical intermediate step for applications approaching the limits of what pgvector can handle on its own. REPORT ### The agentic AI playbook for the enterprise [Read now](http://www.databricks.com/resources/ebook/state-of-ai-agents?itm_source=www&itm_category=blog&itm_page=what-is-pgvector&itm_location=blog-post-inline&itm_component=blog-inline&itm_offer=state-of-ai-agents) ![Image 6: psty](https://www.databricks.com/sites/default/files/2026-04/2026-01-eb-state-of-ai-agents-ps-tn-360x188-2x.png?v=1776285019) ## Limitations and scaling considerations pgvector is powerful, but it comes with tradeoffs: * Performance can degrade at very high vector counts (10M+) without additional optimization or tooling * HNSW indexes are memory-intensive, and large deployments may require significant RAM * Postgres does not provide built-in sharding for vector workloads, so horizontal scaling requires external tooling or a managed provider * Search speed and recall involve a real tradeoff. Recall — the percentage of truly relevant results that are returned — requires deliberate configuration to optimize. Understanding these limitations helps determine when pgvector is sufficient and when additional infrastructure may be needed. ## Getting started with pgvector pgvector can be installed on macOS and most Linux distributions using standard package managers such as Homebrew. It is also available on many managed Postgres platforms, including AWS RDS, Supabase, Azure Database for PostgreSQL, Google Cloud SQL and Neon. Installation and setup instructions are available in the [official pgvector GitHub repository](https://github.com/pgvector/pgvector), which includes step-by-step guidance maintained by the project’s authors. Databricks customers using Postgres can also reference the [Databricks OLTP extensions docs](https://docs.databricks.com/aws/en/oltp/projects/extensions) for platform-specific guidance. ## pgvector and the modern AI data stack pgvector operates in the operational serving layer of an AI system, where low-latency retrieval is required at application runtime. It is commonly used to support semantic search, recommendations and retrieval-augmented generation (RAG) within applications. In contrast, [Databricks Mosaic AI Vector Search](https://docs.databricks.com/aws/en/vector-search/vector-search) is better suited for large-scale, batch-processed AI workloads, where data pipelines are managed in the lakehouse. These environments support centralized data processing, large datasets and complex workflows. These approaches are complementary, and teams often use both across different layers of the stack. pgvector supports real-time application queries, while platforms like Databricks handle large-scale data preparation, embedding generation and model-driven workflows. ## Frequently asked questions **Is pgvector a full vector database?** pgvector enables Postgres to store embeddings and perform similarity search directly on that data. However, it is not a purpose-built vector database. Dedicated vector databases provide additional scalability and performance optimizations for larger workloads. **What is the difference between HNSW and IVFFlat in pgvector?** HNSW is optimized for fast query performance and uses an in-memory graph structure, which requires more memory. IVFFlat has a lower memory footprint and organizes vectors into clusters through a training step, but performance can vary depending on the dataset and workload. The choice depends on whether speed or memory efficiency is the priority. **How many vectors can pgvector handle?** pgvector can typically handle millions to tens of millions of vectors, depending on hardware, indexing strategy and query patterns. As datasets grow, performance may decline without careful tuning or additional tooling. Factors such as available memory, index type and query frequency all influence scalability. **Does pgvector support cosine similarity?** Yes, pgvector supports cosine similarity as one of its primary distance metrics. It measures how closely two vectors point in the same direction, which often reflects semantic similarity in embedding-based applications. This makes it well suited for semantic search, recommendation systems and natural language processing. **Is pgvector free and open source?** Yes, pgvector is an open-source project released under a permissive license. It can be used with standard Postgres installations as well as many managed Postgres services. This makes it an accessible starting point for adding vector search capabilities. **Can pgvector do hybrid search?** Yes, pgvector can be combined with Postgres full-text search to support hybrid search. This allows results to balance semantic relevance with keyword matching, improving both accuracy and usability. Hybrid search is especially useful in scenarios such as product search and documentation search, where both meaning and exact terms are important. ## Choosing the right vector search approach pgvector is a practical starting point for any team that wants to add vector search to an existing Postgres application. By storing embeddings alongside relational data and supporting similarity search natively within the database, it removes the operational overhead of managing a separate vector store. For many workloads — semantic search, RAG pipelines, recommendations and [anomaly detection](https://www.databricks.com/blog/what-is-anomaly-detection) — it delivers what teams need without requiring a new system. As data volumes grow or query demands increase, pgvectorscale can extend how far teams go before a dedicated vector database becomes necessary. For organizations managing large-scale AI workloads across a unified data platform, Databricks Mosaic AI Vector Search offers a complementary approach designed for the lakehouse layer. Together, these tools give teams the flexibility to match their vector search infrastructure to their actual workload requirements — at any scale. Keep up with us Subscribe Contents in this story How pgvector works * [How pgvector works](http://www.databricks.com/blog/what-is-pgvector#section-1) * [Key features of pgvector](http://www.databricks.com/blog/what-is-pgvector#section-2) * [Common use cases for pgvector](http://www.databricks.com/blog/what-is-pgvector#section-3) * [pgvector vs. dedicated vector databases: when to use each](http://www.databricks.com/blog/what-is-pgvector#section-4) * [Limitations and scaling considerations](http://www.databricks.com/blog/what-is-pgvector#section-5) * [Getting started with pgvector](http://www.databricks.com/blog/what-is-pgvector#section-6) * [pgvector and the modern AI data stack](http://www.databricks.com/blog/what-is-pgvector#section-7) * [Frequently asked questions](http://www.databricks.com/blog/what-is-pgvector#section-8) * [Choosing the right vector search approach](http://www.databricks.com/blog/what-is-pgvector#section-9) Recommended for you ![Image 8: 4 Personas AI Agents 1b](https://www.databricks.com/sites/default/files/2026-01/4-personas-ai-agents-1b-og.png?v=1769102648) Data + AI Foundations 14 min read #### [What is a PostgreSQL Database?](http://www.databricks.com/blog/what-is-postgresql-database) ![Image 10: 4 Personas AI Agents 6](https://www.databricks.com/sites/default/files/2026-01/4-personas-ai-agents-6-og.png?v=1769101603) Data + AI Foundations 12 min read #### [What is Retrieval Augmented Generation (RAG)?](http://www.databricks.com/blog/what-is-retrieval-augmented-generation) ![Image 12: 4 Personas AI Agents 4b](https://www.databricks.com/sites/default/files/2026-01/4-personas-ai-agents-4b-og.png?v=1769102019) Data + AI Foundations 6 min read #### [What are Machine Learning Models?](http://www.databricks.com/blog/what-are-machine-learning-models) Share this post * [](https://www.linkedin.com/shareArticle?mini=true&url=https://www.databricks.com/blog/what-is-pgvector&summary=&source=) * [](https://twitter.com/intent/tweet?text=https://www.databricks.com/blog/what-is-pgvector) * [](https://www.facebook.com/sharer/sharer.php?u=https://www.databricks.com/blog/what-is-pgvector) ## Never miss a Databricks post Subscribe to our blog and get the latest posts delivered to your inbox ## Sign up * Work Email * Country Country* By clicking “Subscribe” I understand that I will receive Databricks communications, and I agree to Databricks processing my personal data in accordance with its [Privacy Policy](https://www.databricks.com/legal/privacynotice). Subscribe ## What's next? ### More from the Authors * [MLOps Frameworks: A Complete Guide to Tools and Platforms for Production ML](http://www.databricks.com/blog/mlops-frameworks-complete-guide-tools-and-platforms-production-ml) * [Business Analytics Tools: A Complete Guide for Data-Driven Organizations](http://www.databricks.com/blog/business-analytics-tools-complete-guide-data-driven-organizations) * [What is Machine Learning? How It Works, Types and Use Cases](http://www.databricks.com/blog/machine-learning) ![Image 14: Google Cloud Use Cases: How Enterprises Run Data & AI on GCP with Databricks](https://www.databricks.com/sites/default/files/2026-03/google-cloud-use-cases-enterprises-run-data-ai-gcp-databricks-blog-og.png?v=1774365575) Data + AI Foundations 29 min read #### [Google Cloud Use Cases: How Enterprises Run Data & AI on GCP with Databricks](http://www.databricks.com/blog/google-cloud-use-cases) ![Image 16: 10 Personas Data Management](https://www.databricks.com/sites/default/files/2026-01/10personas-data-management-og.png?v=1769098867) Data + AI Foundations 12 min read #### [What is a Cloud-Based Database Management System?](http://www.databricks.com/blog/what-is-cloud-based-database-management-system) [![Image 18: databricks logo](https://www.databricks.com/sites/default/files/2023-08/databricks-default.png?v=1712162038)](https://www.databricks.com/) Why Databricks Discover * [For App Developers](http://www.databricks.com/developers) * [For Executives](http://www.databricks.com/why-databricks/executives) * [For Startups](http://www.databricks.com/product/startups) * [Lakehouse Architecture](http://www.databricks.com/product/data-lakehouse) * [Databricks AI Research](http://www.databricks.com/research/databricks-ai-research) Customers * [Customer Stories](https://www.databricks.com/customers) Partners * [Partner Overview](http://www.databricks.com/partners) * [Partner Program](http://www.databricks.com/partners/partner-program) * [Find a Partner](http://www.databricks.com/partners/partner-directory) * [Partner Spotlight](http://www.databricks.com/partners/partner-spotlight) * [Cloud Providers](http://www.databricks.com/partners/cloud-partners) * [Partner Solutions](http://www.databricks.com/partners/consulting-and-si/partner-solutions) Why Databricks Discover * [For App Developers](http://www.databricks.com/developers) * [For Executives](http://www.databricks.com/why-databricks/executives) * [For Startups](http://www.databricks.com/product/startups) * [Lakehouse Architecture](http://www.databricks.com/product/data-lakehouse) * [Databricks AI Research](http://www.databricks.com/research/databricks-ai-research) Customers * [Customer Stories](https://www.databricks.com/customers) Partners * [Partner Overview](http://www.databricks.com/partners) * [Partner Program](http://www.databricks.com/partners/partner-program) * [Find a Partner](http://www.databricks.com/partners/partner-directory) * [Partner Spotlight](http://www.databricks.com/partners/partner-spotlight) * [Cloud Providers](http://www.databricks.com/partners/cloud-partners) * [Partner Solutions](http://www.databricks.com/partners/consulting-and-si/partner-solutions) Product Databricks Platform * [Platform Overview](http://www.databricks.com/product/data-intelligence-platform) * [Sharing](http://www.databricks.com/product/delta-sharing) * [Governance](http://www.databricks.com/product/unity-catalog) * [Artificial Intelligence](http://www.databricks.com/product/artificial-intelligence) * [Business Intelligence](http://www.databricks.com/product/business-intelligence) * [Database](http://www.databricks.com/product/lakebase) * [Data Management](http://www.databricks.com/product/delta-lake-on-databricks) * [Data Warehousing](http://www.databricks.com/product/databricks-sql) * [Data Engineering](http://www.databricks.com/product/data-engineering) * [Data Science](http://www.databricks.com/product/data-science) * [Application Development](http://www.databricks.com/product/databricks-apps) * [Security](http://www.databricks.com/product/lakewatch) Pricing * [Pricing Overview](http://www.databricks.com/product/pricing) * [Pricing Calculator](http://www.databricks.com/product/pricing/product-pricing/instance-types) [Open Source](http://www.databricks.com/product/open-source) Integrations and Data * [Marketplace](http://www.databricks.com/product/marketplace) * [IDE Integrations](http://www.databricks.com/product/data-science/ide-integrations) * [Partner Connect](http://www.databricks.com/partnerconnect) Product Databricks Platform * [Platform Overview](http://www.databricks.com/product/data-intelligence-platform) * [Sharing](http://www.databricks.com/product/delta-sharing) * [Governance](http://www.databricks.com/product/unity-catalog) * [Artificial Intelligence](http://www.databricks.com/product/artificial-intelligence) * [Business Intelligence](http://www.databricks.com/product/business-intelligence) * [Database](http://www.databricks.com/product/lakebase) * [Data Management](http://www.databricks.com/product/delta-lake-on-databricks) * [Data Warehousing](http://www.databricks.com/product/databricks-sql) * [Data Engineering](http://www.databricks.com/product/data-engineering) * [Data Science](http://www.databricks.com/product/data-science) * [Application Development](http://www.databricks.com/product/databricks-apps) * [Security](http://www.databricks.com/product/lakewatch) Pricing * [Pricing Overview](http://www.databricks.com/product/pricing) * [Pricing Calculator](http://www.databricks.com/product/pricing/product-pricing/instance-types) Open Source Integrations and Data * [Marketplace](http://www.databricks.com/product/marketplace) * [IDE Integrations](http://www.databricks.com/product/data-science/ide-integrations) * [Partner Connect](http://www.databricks.com/partnerconnect) Solutions Databricks For Industries * [Communications](http://www.databricks.com/solutions/industries/communications) * [Financial Services](http://www.databricks.com/solutions/industries/financial-services) * [Healthcare and Life Sciences](http://www.databricks.com/solutions/industries/healthcare-and-life-sciences) * [Manufacturing](http://www.databricks.com/solutions/industries/manufacturing-industry-solutions) * [Media and Entertainment](http://www.databricks.com/solutions/industries/media-and-entertainment) * [Public Sector](http://www.databricks.com/solutions/industries/public-sector) * [Retail](http://www.databricks.com/solutions/industries/retail-industry-solutions) * [View All](http://www.databricks.com/solutions) Cross Industry Solutions * [Cybersecurity](http://www.databricks.com/solutions/industries/cybersecurity) * [Marketing](http://www.databricks.com/solutions/industries/marketing) [Data Migration](http://www.databricks.com/solutions/migration) [Professional Services](http://www.databricks.com/professional-services) [Solution Accelerators](http://www.databricks.com/solutions/accelerators) Solutions Databricks For Industries * [Communications](http://www.databricks.com/solutions/industries/communications) * [Financial Services](http://www.databricks.com/solutions/industries/financial-services) * [Healthcare and Life Sciences](http://www.databricks.com/solutions/industries/healthcare-and-life-sciences) * [Manufacturing](http://www.databricks.com/solutions/industries/manufacturing-industry-solutions) * [Media and Entertainment](http://www.databricks.com/solutions/industries/media-and-entertainment) * [Public Sector](http://www.databricks.com/solutions/industries/public-sector) * [Retail](http://www.databricks.com/solutions/industries/retail-industry-solutions) * [View All](http://www.databricks.com/solutions) Cross Industry Solutions * [Cybersecurity](http://www.databricks.com/solutions/industries/cybersecurity) * [Marketing](http://www.databricks.com/solutions/industries/marketing) Data Migration Professional Services Solution Accelerators Resources [Documentation](https://www.databricks.com/databricks-documentation) [Customer Support](https://www.databricks.com/support) [Community](https://community.databricks.com/) Learning * [Training](http://www.databricks.com/learn/training/home) * [Certification](https://www.databricks.com/learn/training/certification) * [Free Edition](http://www.databricks.com/learn/free-edition) * [University Alliance](http://www.databricks.com/university) * [Databricks Academy Login](https://www.databricks.com/learn/training/login) Events * [Data + AI Summit](http://www.databricks.com/dataaisummit) * [Data + AI World Tour](http://www.databricks.com/dataaisummit/worldtour) * [AI Days](https://www.databricks.com/ai-days) * [Event Calendar](http://www.databricks.com/events) Blog and Podcasts * [Databricks Blog](http://www.databricks.com/blog) * [Databricks AI R&D Blog](http://www.databricks.com/blog/category/ai) * [Data Brew Podcast](http://www.databricks.com/discover/data-brew) * [Champions of Data & AI Podcast](http://www.databricks.com/discover/champions-of-data-and-ai) Resources Documentation Customer Support Community Learning * [Training](http://www.databricks.com/learn/training/home) * [Certification](https://www.databricks.com/learn/training/certification) * [Free Edition](http://www.databricks.com/learn/free-edition) * [University Alliance](http://www.databricks.com/university) * [Databricks Academy Login](https://www.databricks.com/learn/training/login) Events * [Data + AI Summit](http://www.databricks.com/dataaisummit) * [Data + AI World Tour](http://www.databricks.com/dataaisummit/worldtour) * [AI Days](https://www.databricks.com/ai-days) * [Event Calendar](http://www.databricks.com/events) Blog and Podcasts * [Databricks Blog](http://www.databricks.com/blog) * [Databricks AI R&D Blog](http://www.databricks.com/blog/category/ai) * [Data Brew Podcast](http://www.databricks.com/discover/data-brew) * [Champions of Data & AI Podcast](http://www.databricks.com/discover/champions-of-data-and-ai) About Company * [Who We Are](http://www.databricks.com/company/about-us) * [Our Team](http://www.databricks.com/company/leadership-team) * [Databricks Ventures](http://www.databricks.com/databricks-ventures) * [Contact Us](http://www.databricks.com/company/contact) Careers * [Open Jobs](http://www.databricks.com/company/careers/open-positions) * [Working at Databricks](http://www.databricks.com/company/careers) Press * [Awards and Recognition](http://www.databricks.com/company/awards-and-recognition) * [Newsroom](http://www.databricks.com/company/newsroom) [Security and Trust](http://www.databricks.com/trust) About Company * [Who We Are](http://www.databricks.com/company/about-us) * [Our Team](http://www.databricks.com/company/leadership-team) * [Databricks Ventures](http://www.databricks.com/databricks-ventures) * [Contact Us](http://www.databricks.com/company/contact) Careers * [Open Jobs](http://www.databricks.com/company/careers/open-positions) * [Working at Databricks](http://www.databricks.com/company/careers) Press * [Awards and Recognition](http://www.databricks.com/company/awards-and-recognition) * [Newsroom](http://www.databricks.com/company/newsroom) Security and Trust [![Image 20: databricks logo](https://www.databricks.com/sites/default/files/2023-08/databricks-default.png?v=1712162038)](https://www.databricks.com/) Databricks Inc. 160 Spear Street, 15th Floor San Francisco, CA 94105 1-866-330-0121 * [](https://www.linkedin.com/company/databricks) * [](https://www.facebook.com/pages/Databricks/560203607379694) * [](https://twitter.com/databricks) * [](https://www.databricks.com/feed) * [](https://www.glassdoor.com/Overview/Working-at-Databricks-EI_IE954734.11,21.htm) * [](https://www.youtube.com/@Databricks) ![Image 22](https://www.databricks.com/sites/default/files/2021/02/telco-icon-2.png?v=1715274112) [See Careers](https://www.databricks.com/company/careers) [at Databricks](https://www.databricks.com/company/careers) * [](https://www.linkedin.com/company/databricks) * [](https://www.facebook.com/pages/Databricks/560203607379694) * [](https://twitter.com/databricks) * [](https://www.databricks.com/feed) * [](https://www.glassdoor.com/Overview/Working-at-Databricks-EI_IE954734.11,21.htm) * [](https://www.youtube.com/@Databricks) © Databricks 2026. All rights reserved. Apache, Apache Spark, Spark, the Spark Logo, Apache Iceberg, Iceberg, and the Apache Iceberg logo are trademarks of the [Apache Software Foundation](https://www.apache.org/). * [Privacy Notice](https://www.databricks.com/legal/privacynotice) * |[Terms of Use](https://www.databricks.com/legal/terms-of-use) * |[Modern Slavery Statement](https://www.databricks.com/legal/modern-slavery-policy-statement) * |[California Privacy](https://www.databricks.com/legal/supplemental-privacy-notice-california-residents) * |[Your Privacy Choices](http://www.databricks.com/blog/what-is-pgvector#yourprivacychoices) * ![Image 24](https://www.databricks.com/sites/default/files/2022-12/gpcicon_small.png) ## We Care About Your Privacy Databricks uses cookies and similar technologies to enhance site navigation, analyze site usage, personalize content and ads, and as further described in our [Cookie Notice](https://www.databricks.com/legal/cookienotice). To disable non-essential cookies, click “Reject All”. You can also manage your cookie settings by clicking “Manage Preferences.” Manage Preferences Reject All Accept All ![Image 25: Databricks Company Logo](https://cdn.cookielaw.org/logos/29b588c5-ce77-40e2-8f89-41c4fa03c155/bc546ffe-d1b7-43af-9c0b-9fcf4b9f6e58/1e538bec-8640-4ae9-a0ca-44240b0c1a20/databricks-logo.png) ## Privacy Preference Center Opt-Out Preference Signal Honored ## Privacy Preference Center * ### Your Privacy * ### Strictly Necessary Cookies * ### Performance Cookies * ### Functional Cookies * ### Targeting Cookies * ### TOTHR #### Your Privacy When you visit any website, it may store or retrieve information on your browser, mostly in the form of cookies. This information might be about you, your preferences or your device and is mostly used to make the site work as you expect it to. The information does not usually directly identify you, but it can give you a more personalized web experience. Because we respect your right to privacy, you can choose not to allow some types of cookies. Click on the different category headings to find out more and change our default settings. However, blocking some types of cookies may impact your experience of the site and the services we are able to offer. #### Opting out of sales, sharing, and targeted advertising Depending on your location, you may have the right to opt out of the “sale” or “sharing” of your personal information or the processing of your personal information for purposes of online “targeted advertising.” You can opt out based on cookies and similar identifiers by disabling optional cookies here. To opt out based on other identifiers (such as your email address), submit a request in our [Privacy Request Center](https://privacypreferences.databricks.com/). [More information](https://www.databricks.com/legal/cookienotice) #### Strictly Necessary Cookies Always Active These cookies are necessary for the website to function and cannot be switched off in our systems. They assist with essential site functionality such as setting your privacy preferences, logging in or filling in forms. You can set your browser to block or alert you about these cookies, but some parts of the site will no longer work. #### Performance Cookies - [x] Performance Cookies These cookies allow us to count visits and traffic sources so we can measure and improve the performance of our site. They help us to know which pages are the most and least popular and see how visitors move around the site. #### Functional Cookies - [x] Functional Cookies These cookies enable the website to provide enhanced functionality and personalization. They may be set by us or by third party providers whose services we have added to our pages. If you do not allow these cookies then some or all of these services may not function properly. #### Targeting Cookies - [x] Targeting Cookies These cookies may be set through our site by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant advertisements on other sites. If you do not allow these cookies, you will experience less targeted advertising. #### TOTHR - [x] TOTHR ### Cookie List Consent Leg.Interest - [x] checkbox label label - [x] checkbox label label - [x] checkbox label label Clear * - [x] checkbox label label Apply Cancel Confirm My Choices Allow All [![Image 26: Powered by Onetrust](https://cdn.cookielaw.org/logos/static/powered_by_logo.svg)](https://www.onetrust.com/products/cookie-consent/) ![Image 28](https://bttrack.com/Pixel/Conversion/16418/default?type=img)![Image 29](https://bttrack.com/Pixel/Conversion/16418/landingpage?type=img) ![Image 30](https://insight.adsrvr.org/track/pxl/?adv=b44zbk4&ct=0:hep6l5y&fmt=3) ![Image 31](https://bat.bing.com/action/0?ti=26095796&tm=gtm002&Ver=2&mid=d4ab3e48-ddf3-455a-9bd3-5b0c187389ee&bo=3&sid=d8161cf03ad211f1b7dc2d79cb8e404c&vid=d81653103ad211f1981c11d738461d02&vids=1&msclkid=N&pi=918639831&lg=en-US&sw=800&sh=600&sc=24&tl=What%20is%20pgvector%3F%20%7C%20Databricks&p=https%3A%2F%2Fwww.databricks.com%2Fblog%2Fwhat-is-pgvector&r=<=516&evt=pageLoad&sv=2&asc=G&cdb=AQET&rn=621676)