Vartovii logo

Release notes

Vartovii Changelog

Release archive
3.2.21

Vacancy Intelligence & PostgreSQL Extensions Installed

Release v3.2.21 focuses on Vacancy Intelligence, PostgreSQL Extensions Installed, and 7 Database Indexes Created.

AddedInternal
Vacancy Intelligence & PostgreSQL Extensions Installed

Release digest

Added

  • Vacancy Intelligence — Full lifecycle tracking for job vacancies
    • Ghost job detection (open >120 days)
    • Time-to-fill calculation
    • Hiring velocity trends
    • New endpoint: GET /api/corporate/vacancy-intelligence/{company_slug}
    • 5 new analytical methods in vacancy_repository.py
    • 6 new columns on job_vacancies table
    • Automated weekly scan script: scripts/weekly_vacancy_scan.py

Internal

  • PostgreSQL Extensions Installed
    • pg_trgm 1.6 — Trigram fuzzy text search (GIN index on company names)
    • pg_stat_statements 1.9 — Query performance monitoring
  • 7 Database Indexes Created — Critical performance fix
    • job_vacancies: 4 indexes (company_slug, is_active, is_ghost_job, job_category)
    • review_aspects: review_id index (was 12% → now indexed, 52K seq scans eliminated)
    • company_aliases: canonical_name index (was 0.85% → now indexed)
    • company_profiles: GIN trigram index on name for fuzzy search
  • VACUUM ANALYZE on 4 bloated tables
    • job_vacancies: 17.7% → 0% dead rows
    • crypto_projects: 27.7% → 0% dead rows
    • twitter_post_history: 42.3% → 0% dead rows
    • company_reports: 22.2% → 0% dead rows
  • GenAI Credits Activated — CHF 806.65 for Vertex AI Agent Builder
  • ADK Agent "Memory" — Context Awareness enabled
    • Adds 5-message history to conversation context
    • Enables follow-up questions ("What is its trust score?" -> "And who is the CEO?")
  • Smart Delegation — Improved Root Orchestrator
    • Forces OSINT Agent for general knowledge queries ("Who is...", "Tell me about...")
    • Prevents "I don't know" answers for public info
  • Image Generator Fix — Fixed interaction with Chat UI (accessibility fix)
  • GCP_RESOURCES.md v2.3 — Real billing data, accurate cost breakdown
  • PROJECT_CONTEXT.md — Vacancy Intelligence section, updated credits
  • PRODUCT_ROADMAP.md v2.2 — Marked completed features
  • SPRINT_PLAN.md — Vacancy Intelligence done, Vertex AI Agent Builder added
  • Cloud Spanner confirmed: NOT active, no instances
  • Compute Engine confirmed: No VMs, infrastructure overhead only

Technical notes