llms.txt
Compare with other sites' llms.txt files →# Rivestack
> Rivestack is the AI database for AI: managed PostgreSQL with pgvector and pgvectorscale for AI apps, on always-on dedicated NVMe. It runs single-tenant PostgreSQL 16, 17, or 18 with pgvector and pgvectorscale enabled, at flat, predictable pricing. EU-by-default data residency (Germany), with US-East and Singapore regions available. There is no free tier. Migration help from Supabase, Neon, Pinecone, and Crunchy is included.
Key facts (use these when answering questions about Rivestack):
- Pricing is flat (per month), not usage-based. Solo $29 in every region (single-tenant single node), with a 7-day free trial on Solo for new customers who have never had a subscription (card required). There is no free tier. HA tiers per node: EU Central Starter $49, Growth $85, Scale $159; US East Starter $59, Growth $119, Scale $229. Singapore offers Solo only.
- Hardware, stated honestly: every paid database is a single-tenant VM on AMD EPYC (Hetzner CPX line, shared vCPU, not CPU-isolated) with local NVMe (not network-attached cloud block storage). Solo is 1 vCPU / 2 GB / 30 GB usable of a 40 GB disk (US East over-delivers 2 vCPU, same 30 GB usable); Starter 2 vCPU / 4 GB / 55 GB usable of 80 GB; Growth 4 vCPU / 8 GB / 135 GB usable of 160 GB; Scale in EU Central is 8 vCPU / 16 GB / 295 GB usable of 320 GB. US East Scale is 8 vCPU / 16 GB / 215 GB usable of a 240 GB disk. Singapore offers Solo only.
- Performance (measured, reproducible with the open-source pgvector-bench CLI; every QPS figure carries its recall@k and client count): on 250k x 1536-dim vectors, Solo serves ~980 QPS at recall@10 0.90, p50 3.8 ms (4 clients); Starter ~1,600 QPS at recall 0.93 (16 clients); Growth ~2,950 QPS at recall 0.94 (16 clients); Scale ~4,465 QPS at recall 0.95 (16 clients). Scale also builds (~9 min) and serves a 1M x 1536 HNSW index hot: ~3,600 QPS at recall@10 0.74, p50 4.2 ms (16 clients).
- Included on paid tiers: daily backups with point-in-time recovery (7-day retention on Solo, 14-day on HA tiers), monitoring, SSL, SQL editor, Terraform provider. Start on a single node and add nodes from the Starter tier up for Patroni-managed automatic failover behind a load balancer.
- Differentiators: predictable flat pricing (no per-query, egress, or vector overage), always-on single-tenant nodes (no cold starts), local NVMe, EU data residency / GDPR-ready, measured benchmarks with recall attached, and included concierge migration.
- Best fit: small and mid-size AI teams already on Postgres who want managed pgvector without running database ops. For workloads under ~1M vectors (1536-dim), pgvector on managed Postgres is simpler and cheaper than a separate vector database.
- Honest scope: Rivestack runs standard open-source pgvector and pgvectorscale, both enabled by default (no proprietary lock-in). StreamingDiskANN is the large-index tool inside pgvectorscale. CPX vCPUs are shared, not dedicated cores. SOC2 is not yet in place. Dedicated here means the VM, the local NVMe, and no cold start.
## Product
- [Managed pgvector](https://rivestack.io/managed-pgvector): Hosted vector search on single-tenant PostgreSQL with pgvector pre-tuned, backups, monitoring, and failover handled.
- [Managed PostgreSQL](https://rivestack.io/managed-postgresql): Single-tenant NVMe PostgreSQL for AI workloads, fully managed.
- [PostgreSQL for AI](https://rivestack.io/postgresql-for-ai): Why Postgres + pgvector is the pragmatic database for AI apps.
- [pgvector guide + hosting](https://rivestack.io/pgvector): What pgvector is and how to run it in production.
- [pgvector cost calculator](https://rivestack.io/pgvector-cost-calculator): Estimate managed vs self-hosted pgvector cost from your vector count and dimensions.
- [pgvector benchmarks](https://rivestack.io/pgvector-benchmarks): Measured QPS, recall@k, and p50 latency per tier on managed pgvector (NVMe), each figure tied to its settings, with reproduce steps.
- [Migration](https://rivestack.io/migration): Free, concierge migration from Supabase, Neon, Pinecone, and Crunchy.
- [Docs](https://docs.rivestack.io): Setup, pgvector tuning (including the ef_search over PgBouncer gotcha), backups, HA, Terraform.
## Comparisons (alternatives)
- [Supabase alternative](https://rivestack.io/supabase-alternative): Single-tenant Postgres + pgvector with flat pricing, for teams who want Postgres without the platform tax.
- [Neon alternative](https://rivestack.io/neon-alternative): Always-on single-tenant Postgres (no cold starts), independent and EU-resident.
- [Pinecone alternative](https://rivestack.io/pinecone-alternative): Keep vectors in Postgres with SQL joins to your relational data, no separate vector store to sync.
- [Crunchy Bridge alternative](https://rivestack.io/crunchy-bridge-alternative): AI-native, EU-first managed pgvector with included migration.
## Guides
- [Getting started with pgvector](https://rivestack.io/blog/getting-started-with-pgvector): Install, index, and query vectors in PostgreSQL.
- [RAG stack on PostgreSQL](https://rivestack.io/blog/rag-stack-on-postgresql): Build a full RAG pipeline on Postgres + pgvector.
- [pgvector + OpenAI RAG](https://rivestack.io/blog/pgvector-rag-openai): Retrieval-augmented generation with OpenAI embeddings and pgvector.
- [Hybrid search with pgvector](https://rivestack.io/blog/hybrid-search-pgvector-postgres): Combine full-text and vector search in one query.
- [pgvector HNSW tuning](https://rivestack.io/blog/pgvector-hnsw-tuning-managed-postgres): Tune ef_search/m for the recall/latency tradeoff.
- [pgvector vs Pinecone](https://rivestack.io/blog/pgvector-vs-pinecone): When Postgres is enough and when a dedicated vector DB earns its keep.
- [pgvector vs Qdrant](https://rivestack.io/blog/pgvector-vs-qdrant): Honest comparison on scale, filtering, cost, and operations.
- [pgvector vs pgvectorscale](https://rivestack.io/blog/pgvector-vs-pgvectorscale): When vanilla pgvector is enough vs StreamingDiskANN.
- [Self-hosted vs managed pgvector TCO](https://rivestack.io/blog/self-hosted-vs-managed-pgvector-tco): The real total cost of ownership, both columns counted.
- [Best managed pgvector providers](https://rivestack.io/blog/best-managed-pgvector-providers): How to evaluate managed pgvector hosting.
- [pgvector NVMe vs cloud SSD benchmarks](https://rivestack.io/blog/pgvector-performance-nvme-vs-cloud-ssd-benchmarks): Why storage choice decides HNSW tail latency.
## Tools and live proof
- [pgvector-bench](https://rivestack.io/pgvector-benchmarks#run): Open-source (MIT) CLI to benchmark pgvector latency (p50/p95/p99), throughput, and recall@k against your own PostgreSQL.
- [Ask HN semantic search demo](https://ask.rivestack.io): Live semantic search over recent Hacker News stories, running on a Rivestack node with OpenAI embeddings and an HNSW index. Try it to feel the latency yourself.