Spaces:
Sleeping
Sleeping
File size: 1,845 Bytes
b0b150b |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 |
# MEXAR - Apply Hybrid Search Migration
## What This Does
This SQL script creates the `hybrid_search()` function in your Supabase database,
which combines semantic (vector) and keyword (full-text) search using
Reciprocal Rank Fusion (RRF) algorithm.
## Instructions
1. **Open Supabase Dashboard**
- Go to: https://supabase.com/dashboard
- Select your project: `xmfcidiwovxuihrkfzps`
2. **Navigate to SQL Editor**
- Click "SQL Editor" in the left sidebar
- Click "New Query"
3. **Copy and Paste**
- Open: `backend/migrations/hybrid_search_function.sql`
- Copy ALL the contents
- Paste into the Supabase SQL Editor
4. **Run the Migration**
- Click "Run" button (or press Ctrl+Enter)
- Wait for success message
5. **Verify**
- Run this query to check:
```sql
SELECT routine_name
FROM information_schema.routines
WHERE routine_name = 'hybrid_search';
```
- Should return one row
## Alternative: Run from Command Line (Optional)
If you have `psql` installed:
```bash
psql "postgresql://postgres.xmfcidiwovxuihrkfzps:Yogiji@20122004@aws-1-ap-south-1.pooler.supabase.com:5432/postgres" -f migrations/hybrid_search_function.sql
```
## What Gets Created
- **Function**: `hybrid_search(vector, text, integer, integer)`
- **Indexes**:
- `idx_document_chunks_content_tsvector` (GIN index for full-text search)
- `idx_document_chunks_agent_id` (B-tree index for filtering)
- `idx_document_chunks_embedding` (IVFFlat index for vector search)
## Troubleshooting
**Error: "type vector does not exist"**
- Run: `CREATE EXTENSION IF NOT EXISTS vector;`
- Then retry the migration
**Error: "table document_chunks does not exist"**
- Restart your backend server to create tables
- Then retry the migration
---
**After running this migration**, your system will be ready for hybrid search!
|