- Notifications
You must be signed in to change notification settings - Fork328
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
SilasMarvin merged 21 commits intomasterfromsilas-semantic-search-in-postgres-in-15-minutesJun 18, 2024
Uh oh!
There was an error while loading.Please reload this page.
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
SilasMarvin00bd75d
Cleanups
SilasMarvin068af92
Ready for review
SilasMarvina9148da
Cleanup first paragraph
SilasMarvin3e0fa33
A few suggestions (#1536)
levkkc71fcd2
Add reason on why to use semantic search
SilasMarvin9b6e75f
Clean up spelling errors
SilasMarvinb451c9b
Fix more small spelling errors
SilasMarvind418deb
Finish timings
SilasMarvin84872ac
Update pgml-cms/blog/semantic-search-in-postgres-in-15-minutes.md
SilasMarvin1686f93
Update pgml-cms/blog/semantic-search-in-postgres-in-15-minutes.md
SilasMarvinb2b9d88
Update pgml-cms/blog/semantic-search-in-postgres-in-15-minutes.md
SilasMarvinb8766bd
Update pgml-cms/blog/semantic-search-in-postgres-in-15-minutes.md
SilasMarvin4574183
Update pgml-cms/blog/semantic-search-in-postgres-in-15-minutes.md
SilasMarvin4db2149
Update pgml-cms/blog/semantic-search-in-postgres-in-15-minutes.md
SilasMarvin68368e2
Update pgml-cms/blog/semantic-search-in-postgres-in-15-minutes.md
SilasMarvinaf8dd3e
Convert italics back to backticks
SilasMarvin2c156ae
Remove hnsw link out
SilasMarvinfaf0be1
Alude to arrays
SilasMarvin27445f5
Finalize post
SilasMarvin427f77f
Merge branch 'master' into silas-semantic-search-in-postgres-in-15-mi…
SilasMarvinFile filter
Filter by extension
Conversations
Failed to load comments.
Loading
Uh oh!
There was an error while loading.Please reload this page.
Jump to
Jump to file
Failed to load files.
Loading
Uh oh!
There was an error while loading.Please reload this page.
Diff view
Diff view
Cleanup first paragraph
- Loading branch information
Uh oh!
There was an error while loading.Please reload this page.
commita9148da8fcc56bfb40b25fda322c7c409d54bb30
There are no files selected for viewing
6 changes: 3 additions & 3 deletionspgml-cms/blog/semantic-search-in-postgres-in-15-minutes.md
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.Learn more about bidirectional Unicode characters
Original file line number | Diff line number | Diff line change |
---|---|---|
@@ -20,11 +20,11 @@ June 15, 2024 | ||
## What is and is not Semantic Search | ||
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 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. | ||
SilasMarvin marked this conversation as resolved. Show resolvedHide resolvedUh oh!There was an error while loading.Please reload this page. | ||
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 | ||
Oops, something went wrong.
Uh oh!
There was an error while loading.Please reload this page.
Add this suggestion to a batch that can be applied as a single commit.This suggestion is invalid because no changes were made to the code.Suggestions cannot be applied while the pull request is closed.Suggestions cannot be applied while viewing a subset of changes.Only one suggestion per line can be applied in a batch.Add this suggestion to a batch that can be applied as a single commit.Applying suggestions on deleted lines is not supported.You must change the existing code in this line in order to create a valid suggestion.Outdated suggestions cannot be applied.This suggestion has been applied or marked resolved.Suggestions cannot be applied from pending reviews.Suggestions cannot be applied on multi-line comments.Suggestions cannot be applied while the pull request is queued to merge.Suggestion cannot be applied right now. Please check back later.