cevian

@ceviantech.bsky.social

101 Followers 193 Following

Tech lead for pgai, pgvectorscale, and all other AI things @ Timescale. Postgres rocks!

Vectorizer architecture and code snippet
Query latency and throughput of pgvector and pgvectorscale vs Qdrant on 50M embeddings at 768 dimensions @ 99% recall. Qdrant has somewhat lower latency, although both are below 100ms. pgvector and pgvectorscale have siginificantlt higher throughput (472 vs 41 qps)
select ai.load_dataset('rajpurkar/squad', table_name => 'squad');
Table of pros/cons for ivfflat, hnsw and StreamingDiskANN
The "easy mode" open source AI stack