# Instaclustr for PostgreSQL® Releases Support for pgvector [Blog](/blog/)>[Technology](/blog/category/technical/)>Instaclustr for PostgreSQL® Releases Support for pgvector Instaclustr for PostgreSQL® Releases Support for pgvector ========================================================= December 19, 2023 | By [ Chris Carter](https://www.instaclustr.com/blog/author/christopher-carter/) [ ](https://x.com/intent/tweet?text=Instaclustr%20for%20PostgreSQL%C2%AE%20Releases%20Support%20for%20pgvector&url=https://www.instaclustr.com/blog/instaclustr-for-postgresql-releases-support-for-pgvector/) [ ](https://www.linkedin.com/shareArticle?mini=true&url=https://www.instaclustr.com/blog/instaclustr-for-postgresql-releases-support-for-pgvector/&title=&summary=Instaclustr%20for%20PostgreSQL%C2%AE%20Releases%20Support%20for%20pgvector&source=) The pgvector open source extension for similarity search is now available as an add-on to your Instaclustr for PostgreSQL**®** services. ### What is pgvector? The pgvector extension provides the ability to store and search ML-generated vector type data. Using a specific index type for querying a table, pgvector allows you to find a vector’s exact or approximate nearest neighbors, or data items. Utilizing machine learning models, all data items from a set can be mapped into a single n–dimensional vector space, irrespective of the dataset’s size. Known as data vectorizing, this process transforms data items into vectors—data structures with a magnitude and direction; pgvector is one such tool that enables AI operations on this vectorized data. ### Why use pgvector? In the realm of machine learning (ML), real-world entities like text, images, video, or audio are represented as continuous numbers in a high-dimensional vector space. These numerical representations, known as vector embeddings, enable ML algorithms to discern relationships, detect patterns, and make predictions. Vector similarity, calculated generally using distance metrics, plays a crucial role in identifying relationships between these vector representations, making it easy to compute and scale similarities. To use pgvector, create a new Instaclustr for PostgreSQL database with the extension installed, and then generate embeddings for your data (such as a product catalog) using tools like the [OpenAI API client](https://platform.openai.com/docs/api-reference/embeddings/create). These embeddings are stored in Instaclustr for PostgreSQL using the pgvector extension and can be used for vector similarity searches on the product catalogue. By default, pgvector performs exact nearest neighbor search, ensuring perfect recall. However, adding an index for approximate nearest neighbor search can enhance search speed at the cost of some recall. The pgvector extension allows you to conduct vector similarity search and use embedding techniques directly in Instaclustr for PostgreSQL. It manages high-dimensional vector data within the database efficiently for tasks like similarity search, model training, data augmentation, or machine learning. pgvector enhances the similarity search experience by improving search speed and accuracy. ### Real-life use cases Vector embeddings similarity searches have numerous industry applications, such as: - **E-commerce**: Similarity searches can enhance product recommendations, improving the customer’s shopping experience and increasing the chances of additional sales. - **Recommendation systems**: Across various digital platforms, vector similarity is used to suggest content that is similar to what users have previously interacted with, enhancing user engagement. - **Fraud detection**: In the financial sector, vector similarity can be used for quick detection and prevention of fraud, safeguarding both the financial institution and the user. pgvector is available on any of our PostgreSQL clusters at no additional cost. Try pgvector yourself with a [free trial](https://console2.instaclustr.com/signup) today! Or if you’re interested in getting more information on how exactly to use pgvector, have a look at what else we’ve been [working on.](https://www.instaclustr.com/blog/how-to-improve-your-llm-accuracy-and-performance-with-pgvector-and-postgresql-introduction-to-embeddings-and-the-role-of-pgvector/) ### About the author **[Chris Carter](https://www.instaclustr.com/blog/author/christopher-carter/)** | Principal Product Manager With extensive expertise in open source technologies, Chris drives innovation and excellence in the NetApp Instaclustr Managed Platform with a focus on Apache Kafka and Cassandra. With his passion for classical statistics and process improvement, Chris leverages his skills to ensure the integration of business strategy and direction into NetApp solutions. [ Add Instaclustr as a preferred source on Google ](https://google.com/preferences/source?q=instaclustr.com) ![mail icon]()#### Get the latest articles for open sourceIn your inbox Sign up now ### Related content [ 6 Reasons to Migrate From Oracle to PostgreSQL® PostgreSQL is a powerful and versatile database management system if you’re considering migrating from Oracle to PostgreSQL... ](https://www.instaclustr.com/blog/oracle-to-postgresql/) [ Apache Cassandra® vs. PostgreSQL®: An Overview Apache Cassandra® and PostgreSQL® are both open source databases built to handle incredible amounts of data, backed with robust ... ](https://www.instaclustr.com/blog/apache-cassandra-vs-postgresql/) [ Change Data Capture (CDC) With Kafka® Connect and the Debezium PostgreSQL® Source Connector After learning how to capture change data from an Apache Cassandra® database and produce event streams in Apache Kafka®, But now ... ](https://www.instaclustr.com/blog/change-data-capture-cdc-with-kafka-connect-and-the-debezium-postgresql-source-connector/) ×Sign upto ourNewsletter -----------------------