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 pgml.rank docs#1514

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 4 commits intomasterfromsilas-add-rank-docs
Jun 12, 2024
Merged
Changes from1 commit
Commits
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
Clarify examples and add some more information about cross-encoders
  • Loading branch information
@SilasMarvin
SilasMarvin committedJun 7, 2024
commitf9c5ff2e82ecd96ffef0daaa08c92bb57099032c
10 changes: 8 additions & 2 deletionspgml-cms/docs/api/sql-extension/pgml.rank.md
View file
Open in desktop
Original file line numberDiff line numberDiff line change
Expand Up@@ -19,16 +19,22 @@ pgml.rank(

## Example

Copy link
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others.Learn more.

Copy link
ContributorAuthor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others.Learn more.

How does this look:f9c5ff2

Ranking documents is as simple as calling the the function with the documents you want to rank, and text you want to rank against:

```postgresql
SELECT pgml.rank('mixedbread-ai/mxbai-rerank-base-v1', 'test', ARRAY['doc1', 'doc2']);
```

By default the `pgml.rank()` function will return and rank all of the documents. The function can be configured to only return the relevance score and index of the top k documents by setting `return_documents` to `false` and `top_k` to the number of documents you want returned.

```postgresql
SELECT pgml.chunk('mixedbread-ai/mxbai-rerank-base-v1', 'test', ARRAY['doc1', 'doc2'], '{"return_documents": false, "top_k": 10}'::JSONB);
SELECT pgml.rank('mixedbread-ai/mxbai-rerank-base-v1', 'test', ARRAY['doc1', 'doc2'], '{"return_documents": false, "top_k": 10}'::JSONB);
```

## Supported ranking models

We support the following ranking models:
We currently support cross-encoders for re-ranking. Check out [Sentence Transformer's documentation](https://sbert.net/examples/applications/cross-encoder/README.html) for more information on how cross-encoders work.

By default we provide the following ranking models:

* `mixedbread-ai/mxbai-rerank-base-v1`

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others.Learn more.

Can I use other models from hugging face? There's no mention here.

Copy link
ContributorAuthor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others.Learn more.

Yes you can. If you are using a serverless hosted database you can request for that model specifically. Is there a model you are interested in using that is not here?

katopz reacted with thumbs up emoji

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others.Learn more.

Just to make sure that I can use any because embedding and reranking models will get update regularly.
I currently pick:

SilasMarvin reacted with thumbs up emoji
Copy link
ContributorAuthor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others.Learn more.

Those should work. If you are using serverless and want to use them, you will need to request access to them. Let me know if you have any problems and I'm happy to take a look!

katopz reacted with thumbs up emoji

[8]ページ先頭

©2009-2025 Movatter.jp