Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Added blog post semantic search in postgres in 15 minutes#1535

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to ourterms of service andprivacy statement. We’ll occasionally send you account related emails.

Already on GitHub?Sign in to your account

Merged
Merged
Changes from1 commit
Commits
Show all changes
21 commits
Select commitHold shift + click to select a range
18f8f44
Preliminary draft of semantic search in postgres in 15 minutes
SilasMarvinJun 11, 2024
00bd75d
Cleanups
SilasMarvinJun 12, 2024
068af92
Ready for review
SilasMarvinJun 14, 2024
a9148da
Cleanup first paragraph
SilasMarvinJun 17, 2024
3e0fa33
A few suggestions (#1536)
levkkJun 17, 2024
c71fcd2
Add reason on why to use semantic search
SilasMarvinJun 17, 2024
9b6e75f
Clean up spelling errors
SilasMarvinJun 17, 2024
b451c9b
Fix more small spelling errors
SilasMarvinJun 17, 2024
d418deb
Finish timings
SilasMarvinJun 18, 2024
84872ac
Update pgml-cms/blog/semantic-search-in-postgres-in-15-minutes.md
SilasMarvinJun 18, 2024
1686f93
Update pgml-cms/blog/semantic-search-in-postgres-in-15-minutes.md
SilasMarvinJun 18, 2024
b2b9d88
Update pgml-cms/blog/semantic-search-in-postgres-in-15-minutes.md
SilasMarvinJun 18, 2024
b8766bd
Update pgml-cms/blog/semantic-search-in-postgres-in-15-minutes.md
SilasMarvinJun 18, 2024
4574183
Update pgml-cms/blog/semantic-search-in-postgres-in-15-minutes.md
SilasMarvinJun 18, 2024
4db2149
Update pgml-cms/blog/semantic-search-in-postgres-in-15-minutes.md
SilasMarvinJun 18, 2024
68368e2
Update pgml-cms/blog/semantic-search-in-postgres-in-15-minutes.md
SilasMarvinJun 18, 2024
af8dd3e
Convert italics back to backticks
SilasMarvinJun 18, 2024
2c156ae
Remove hnsw link out
SilasMarvinJun 18, 2024
faf0be1
Alude to arrays
SilasMarvinJun 18, 2024
27445f5
Finalize post
SilasMarvinJun 18, 2024
427f77f
Merge branch 'master' into silas-semantic-search-in-postgres-in-15-mi…
SilasMarvinJun 18, 2024
File filter

Filter by extension

Filter by extension

Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
PrevPrevious commit
NextNext commit
Cleanup first paragraph
  • Loading branch information
@SilasMarvin
SilasMarvin committedJun 17, 2024
commita9148da8fcc56bfb40b25fda322c7c409d54bb30
View file
Open in desktop
Original file line numberDiff line numberDiff line change
Expand Up@@ -20,11 +20,11 @@ June 15, 2024

## What is and is not Semantic Search

Semantic searchis a new form ofmachine learningpowered search that doesn’t rely on any form of keyword matching, but transforms text into embeddingsandperforms nearest neighborssearch.
Semantic searchusesmachine learningto understand the meaning of text by converting it into numerical vectors, allowing for more accurateandcontext-awaresearch results.

It is not a complete replacement for fulltext search. In many cases fulltext searchis capable of outperformingsemantic search. Specifically, if a user knows the exact phrasein a documentthey want to match, fulltext search is faster and guaranteed to return the correct result while semantic search is only likely to return the correct result. Fulltext search and semantic search can be combined to create powerful and robust search systems.
It is not a complete replacement for full-text search. In many cases, full-text searchcan outperformsemantic search. Specifically, if a user knows the exact phrase they want to match in a document, full-text search is faster and guaranteed to return the correct result, whereas semantic search is only likely to return the correct result. Full-text search and semantic search can be combined to create powerful and robust search systems.

Semantic search is not just for machine learning engineers. Theactualsystem behind semantic search is relatively easy to implement and thanks to new Postgres extensions like pgml and pgvector, is readily available to SQL developers. Just asit is expected formodern SQL developers to be familiar with and capable of implementing fulltext search,soon SQL developerswill be expected to implement semantic search.
Semantic search is not just for machine learning engineers. The system behind semantic search is relatively easy to implement, and thanks to new Postgres extensions like pgml and pgvector,itis readily available to SQL developers. Just as modern SQL developersare expectedto be familiar with and capable of implementing full-text search,theywillsoonbe expected to implement semantic search as well.

## Embeddings 101

Expand Down
Loading

[8]ページ先頭

©2009-2025 Movatter.jp