llms.txt Content
# ParadeDB
> ParadeDB is a transactional alternative to Elasticsearch built on Postgres. It is a PostgreSQL-native search and analytics engine - a columnstore index for OLAP and a BM25 inverted index for full-text search, all inside Postgres as an extension. ParadeDB makes Postgres fast for both analytics and search without ETL or external systems.
## Website
- [Homepage](https://www.paradedb.com)
- [Blog](https://www.paradedb.com/blog)
- [Learn](https://www.paradedb.com/learn)
- [Sitemap](https://www.paradedb.com/sitemap.xml)
- [RSS Feed](https://www.paradedb.com/feed.xml)
## Blog
- [How We Optimized Top K in Postgres](https://www.paradedb.com/blog/optimizing-top-k)
- [Retrieve and Rerank: Personalized Search Without Leaving Postgres](https://www.paradedb.com/blog/personalized-search-in-postgresql)
- [Hybrid Search in PostgreSQL: The Missing Manual](https://www.paradedb.com/blog/hybrid-search-in-postgresql-the-missing-manual)
- [From Text to Token: How Tokenization Pipelines Work](https://www.paradedb.com/blog/when-tokenization-becomes-token)
- [Postgres as a Search Engine: The Write Performance Problem](https://www.paradedb.com/blog/increased-write-performance)
- [Teaching Postgres to Facet Like Elasticsearch](https://www.paradedb.com/blog/faceting)
- [Deep Dive into ParadeDB's v2 API: The Future of SQL Search](https://www.paradedb.com/blog/v2api)
- [ParadeDB 0.20.0: Simpler and Faster](https://www.paradedb.com/blog/paradedb-0-20-0)
- [The ACID Test: Why We Think Search Needs Transactions](https://www.paradedb.com/blog/elasticsearch-acid-test)
- [Elasticsearch Was Never a Database](https://www.paradedb.com/blog/elasticsearch-was-never-a-database)
- [Syncing with Postgres: Logical Replication vs. ETL](https://www.paradedb.com/blog/etl-vs-logical-replication)
- [Announcing Our $12M Series A](https://www.paradedb.com/blog/series-a-announcement)
- [We Made Postgres Writes Faster, but it Broke Replication](https://www.paradedb.com/blog/lsm-trees-in-postgres)
- [A