--- title: Speed up PostgreSQL pgvector queries with indexes description: This post explains how indexes can speed up PostgreSQL pgvector queries. It introduces the pgvector extension, which allows for similarity searches on AI... canonical: https://daily.dev/posts/speed-up-postgresql-pgvector-queries-with-indexes-4q5hmqrxx twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Speed up PostgreSQL pgvector queries with indexes | daily.dev og:description: This post explains how indexes can speed up PostgreSQL pgvector queries. It introduces the pgvector extension, which allows for similarity searches on AI... og:url: https://daily.dev/posts/speed-up-postgresql-pgvector-queries-with-indexes-4q5hmqrxx og:image: https://api.daily.dev/og/posts/4Q5HMQRXx.png og:image:alt: Speed up PostgreSQL pgvector queries with indexes og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Speed up PostgreSQL pgvector queries with indexes **[EverSQL](https://daily.dev/sources/eversql)** · 39 min read · 2 upvotes · 0 comments ## Summary This post explains how indexes can speed up PostgreSQL pgvector queries. It introduces the pgvector extension, which allows for similarity searches on AI embeddings. The post also discusses different similarity metrics used in vector queries. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: --- Tags: [#performance](https://daily.dev/tags/performance), [#pgvector](https://daily.dev/tags/pgvector), [#postgresql](https://daily.dev/tags/postgresql) [View this post on daily.dev](https://daily.dev/posts/speed-up-postgresql-pgvector-queries-with-indexes-4q5hmqrxx) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"Speed up PostgreSQL pgvector queries with indexes","url":"https://daily.dev/posts/speed-up-postgresql-pgvector-queries-with-indexes-4q5hmqrxx","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/speed-up-postgresql-pgvector-queries-with-indexes-4q5hmqrxx"},"datePublished":"2024-03-08T14:45:51.469Z","dateModified":"2024-05-24T02:12:50.819Z","description":"This post explains how indexes can speed up PostgreSQL pgvector queries. It introduces the pgvector extension, which allows for similarity searches on AI...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/0bac32fc3623a57a04042fb13e2ebdab?_a=AQAEufR","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/0bac32fc3623a57a04042fb13e2ebdab?_a=AQAEufR","isAccessibleForFree":true,"articleSection":"EverSQL","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"EverSQL","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/a9691b33d7534798adee3c98d424a6f1","url":"https://daily.dev/sources/eversql"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/speed-up-postgresql-pgvector-queries-with-indexes-4q5hmqrxx","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":2},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"performance,pgvector,postgresql","timeRequired":"PT39M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"EverSQL","item":"https://daily.dev/sources/eversql"},{"@type":"ListItem","position":3,"name":"Speed up PostgreSQL pgvector queries with indexes"}]} ```