Skip to Main Content
Leverage Your OCI & PostgreSQL Skills to Accelerate AI outcomes

About This Workshop

Youtube Video

About This Workshop
Expect practical patterns for Postgres schema design, connection pooling, indexing, cost awareness, scaling—plus selection of Embedding models and OCI Generative AI service for inference.

- Schema and embedding strategy for hybrid (full‑text + vector) retrieval on OCI PostgreSQL/pgvector
- Practical ranking: weighted tsvectors, trigram similarity, and rank fusion for quality and recall
- Indexing for performance: GIN, ivfflat/HNSW trade‑offs, and query patterns
- RAG orchestration with OCI Generative AI.

Workshop Info

1 hour, 30 minutes
  • Lab 1
    Create OCI PostgreSQL Server
    Setup OCI API authentication Key
  • Lab 2
    Deploy App Schema and App on OCI VM shape
    Load Dataset to pgvector 
  • Lab 3
    Run inference and AI search app
  • Sample - Familiarity with Database is desirable, but not required
  • Some understanding of cloud and database terms is helpful
  • Familiarity with Oracle Cloud Infrastructure (OCI) is helpful

Other Workshops you might like