Comparing PostgreSQL text search tools and external search engines.
cd benchmarks/text-search
make up
make install-extensions
# Run benchmarks (uses synthetic data by default)
go run cmd/bench/main.go- Wikipedia: Downloaded to
data/wikipedia.parquet(~770K articles, 76MB) - Ecommerce: Use synthetic generator (or download sample from
./scripts/download_ecommerce.sh) - Q&A: Use synthetic generator (or download from
./scripts/download_stackoverflow.sh)
| # | Tool | Type | Port |
|---|---|---|---|
| 1 | tsvector | Native PostgreSQL | 5432 |
| 2 | pg_trgm | PostgreSQL Extension | 5432 |
| 3 | pgroonga | PostgreSQL Extension | 5432 |
| 4 | ParadeDB (pg_search) | PostgreSQL Extension | 5433 |
| 5 | pg_textsearch | PostgreSQL Extension | 5432 |
| 6 | Elasticsearch | External | 9200 |
| 7 | Meilisearch | External | 7700 |