Lemmy.zip
  • Communities
  • Create Post
  • Create Community
  • Aquileo | heart
    Support Lemmy
  • Aquileo | search
    Search
  • Login
  • Sign Up
steam_lover@sh.itjust.works to PostgreSQL@programming.dev · 4 days ago

Hybrid Search Patterns with Postgres and pgvector

www.crunchydata.com

Aquileo | external-link
Aquileo | message-square
0
Aquileo | link
Aquileo | fedilink
3
Aquileo | external-link

Hybrid Search Patterns with Postgres and pgvector

www.crunchydata.com

steam_lover@sh.itjust.works to PostgreSQL@programming.dev · 4 days ago
Aquileo | message-square
0
Aquileo | link
Aquileo | fedilink
Hybrid Search Patterns with Postgres and pgvector | Crunchy Data Blog
www.crunchydata.com
Aquileo | external-link
Filtered vector search in Postgres forces a tradeoff between recall and speed because ANN indexes and WHERE clauses do not intersect like B-trees. Read about pgvector iterative scans, partial HNSW indexes, oversampling with pg_stats, caching, and more.
Aquileo | alert-triangle
You must log in or # to comment.

PostgreSQL@programming.dev

postgresql@programming.dev

Subscribe from Remote Instance

Create a post
You are not logged in. However you can subscribe from another Fediverse account, for example Lemmy or Mastodon. To do this, paste the following into the search field of your instance: [email protected]

The world’s most advanced open source relational database

Project
  • About (history)
  • Docs
  • Donate to PostgreSQL
  • Wiki
  • Planet PostgreSQL
  • IRC
  • Mailing lists:
    • pgsql-announce
    • pgsql-hackers (developers)
    • pgsql-general
    • pgsql-jobs
  • User Groups
Events
  • SEAPUG Summer BBQ, 6 July in Seattle
  • SFBA PostgreSQL Meetup, 12 July
  • Chicago PostgreSQL Meetup, 19 July
  • PGDay UK 2023, 12 September in London
  • PGConf 2023, 3-5 October in New York City
  • PGDay Israel 2023, 19 October
  • PGConf.EU 2023, 12-15 December in Prague
Podcasts
  • postgres.fm (feed)
Related Fediverse communities
  • c/SQL on programming.dev
  • #sql on Mastodon
  • #postgresql on Mastodon
Visibility: Public
Aquileo | globe

This community can be federated to other instances and be posted/commented in by their users.

  • 1 user / day
  • 5 users / week
  • 6 users / month
  • 98 users / 6 months
  • 13 local subscribers
  • 2.2K subscribers
  • 196 Posts
  • 111 Comments
  • Modlog
  • mods:
  • Ategon@programming.dev
  • starman@programming.dev
  • Jason Novinger@programming.dev
  • UI: 0.19.19
  • BE: 0.19.19-jemalloc
  • Modlog
  • Legal
  • Instances
  • Docs
  • Code
  • join-lemmy.org