Both are open source retrieval options with comparable terms, so the choice comes down to which model of the problem you prefer — compare the descriptions below rather than the licence.
Vector search inside the Postgres you already run.
Correct default under roughly ten million vectors. Reach for a dedicated store when it stops being.
Embedded multimodal store backed by the Lance columnar format.
| pgvector | LanceDB | |
|---|---|---|
| Licence | Open source | Open source |
| Pricing | open source | open source |
| Self-hostable | Yes | Yes |
| Languages | Any language | Python, TypeScript |
| Install | — | pip install lancedb |
| Keys required | None | None |
Both are open source retrieval options with comparable terms, so the choice comes down to which model of the problem you prefer — compare the descriptions below rather than the licence. pgvector: Vector search inside the Postgres you already run. LanceDB: Embedded multimodal store backed by the Lance columnar format.
pgvector can run on your own infrastructure. LanceDB can run on your own infrastructure.
pgvector is open source (open source). LanceDB is open source (open source).
Every page here answers to Accept: text/markdown and returns the same content at roughly a tenth the tokens. No separate site, no toggle — same URL.
curl -s -H "Accept: text/markdown" https://newagent.build/compare/pgvector-vs-lancedb