Community

#postgres on the community blog

Community posts tagged postgres.

Write a post Guidelines

#python 6 #ai 3 #performance 3 #fastapi 2 #llm 2 #git 2 #postgres 2 #vector-search 2 #rag 2 #database 2 #sql 2 #tooling 2 #devops 2 #backend 2

Tools

pgvector: vector search inside the Postgres you already run
pgvector adds a vector type, distance operators and approximate indexes to PostgreSQL. Here is the setup, the queries, the index choices and when a separate vector database is still worth it.
RecallRun Editors · 30 Sept 2026 · 3 min read
Tech articles

Composite indexes in SQL: why column order decides everything
How a multi-column B-tree index is actually used, the leftmost-prefix rule, and a simple way to choose column order for filters, ranges and sorting, with EXPLAIN examples.
RecallRun Editors · 21 Sept 2026 · 3 min read

Write for RecallRun

Share a tech article or a tool you built. Every post is checked and reviewed before it goes live.