Deploy ParadeDB

One Postgres for app data, BM25 full-text and vector search, pinned

Deploy ParadeDB

/var/lib/postgresql

Deploy and Host ParadeDB on Railway

ParadeDB is PostgreSQL with the open-source pg_search extension, which adds BM25 full-text search, fast filters, facets and aggregations. Vector search comes from pgvector in the same database, so application data, keyword search and vector retrieval stay in one Postgres you query with standard SQL and ACID transactions.

About Hosting ParadeDB

This template runs ParadeDB 0.26.7 on PostgreSQL 18, built from a public GitHub repo that pins the official paradedb/paradedb image by version and digest. Data lives on a Railway volume, the superuser password is generated at deploy time, and a health endpoint answers only once Postgres accepts connections. On first start, pg_search, vector, postgis, pg_ivm and pg_stat_statements are created in the default database and in template1. Other services connect over the private network with DATABASE_URL, and a TCP proxy with TLS gives DATABASE_PUBLIC_URL for tools outside Railway. Version updates arrive as Railway update notices.

Common Use Cases

  • Full-text product, document or support-ticket search with BM25 ranking, without running Elasticsearch next to Postgres
  • Hybrid keyword and vector retrieval for AI and RAG applications
  • Filtered list views and dashboards with fast counts, facets and aggregations

Dependencies for ParadeDB Hosting

  • None beyond this one service: the image bundles PostgreSQL 18 and the extensions
  • A Railway volume for the data directory, created by the template

Deployment Dependencies

Implementation Details

Connect from another Railway service with DATABASE_URL=${{ParadeDB.DATABASE_URL}}, or from your machine with psql "$DATABASE_PUBLIC_URL". Then create a BM25 index and search:

CREATE TABLE items (id serial PRIMARY KEY, description text, rating int);
INSERT INTO items (description, rating) VALUES ('Ergonomic metal keyboard', 4), ('Sleek running shoes', 5);
CREATE INDEX items_idx ON items USING bm25 (id, description, rating);
SELECT description, pdb.score(id) FROM items WHERE description ||| 'keyboard' ORDER BY 2 DESC;

Memory settings start at shared_buffers=512MB and work_mem=16MB; change them with ALTER SYSTEM SET ... and a redeploy. When you apply a template update, the start script runs ALTER EXTENSION pg_search UPDATE for you. Read the repo's CHANGELOG.md before applying an update.

Why Deploy ParadeDB on Railway?

Railway is a singular platform to deploy your infrastructure stack. Railway will host your infrastructure so you don't have to deal with configuration, while allowing you to vertically and horizontally scale it.

By deploying ParadeDB on Railway, you are one step closer to supporting a complete full-stack application with minimal burden. Host your servers, databases, AI agents, and more on Railway.


Template Content

More templates in this category

View Template
RustFS | (Just Updated) S3 Object Store, Public URL and Keys Set
S3-compatible object store, keys and public URL preset, volume kept

SuperSlowSloth
0
View Template
TimescaleDB
A PostgreSQL-based time-series database for analytics on Railway.

Rakit
1
View Template
NEW
Neo4j 2026.10 Community
Neo4j graph database with APOC, Browser, Bolt TCP proxy and a volume

My Projects
0