BM25 in PostgreSQL(blog.vectorchord.ai)

129 points by gaocegege 1 year ago | 25 comments

VectorChord: Store 400k Vectors for $1 in PostgreSQL(blog.pgvecto.rs)

147 points by gaocegege 1 year ago | 36 comments

Binary vector search is better than FP32 vectors(blog.pgvecto.rs)

105 points by gaocegege 2 years ago | 24 comments

Supercharge vector search with ColBERT rerank in PostgreSQL(blog.vectorchord.ai)

54 points by gaocegege 1 year ago | 14 comments

Overcoming pitfalls of Postgres logical decoding(blog.peerdb.io)

27 points by saisrirampur 2 years ago | 4 comments

Vector database that can index 1B vectors in 48M(vectroid.com)

82 points by mathewpregasen 1 year ago | 46 comments

Making Postgres slower(byteofdev.com)

320 points by AsyncBanana 1 year ago | 35 comments

A ByteofDev blog post humorously exploring how to tune PostgreSQL configuration settings to make the database as slow as possible.

Building durable workflows on Postgres(dbos.dev)

329 points by KraftyOne 5 months ago | 137 comments

DBOS blog post by Peter Kraft arguing that Postgres alone is sufficient to build durable workflow execution, describing DBOS's architecture.

PostgreSQL reconsiders its process-based model(lwn.net)

761 points by todsacerdoti 3 years ago | 338 comments

LWN article by Jonathan Corbet on PostgreSQL developers discussing moving from a process-per-connection model to a threaded architecture.

PostgreSQL for Everything(raphaelbauer.com)

412 points by karlmush 2 months ago | 238 comments

A blog post by Raphael Bauer arguing for using PostgreSQL as the single backend for many workloads instead of specialized tools.

Go ahead, self-host Postgres(pierce.dev)

635 points by pavel_lishin 10 months ago | 373 comments

A blog post on pierce.dev arguing that self-hosting PostgreSQL is a reasonable alternative to managed database services.

What I wish someone told me about Postgres(challahscript.com)

389 points by todsacerdoti 1 year ago | 161 comments

A blog post cataloging practical lessons and tips about working with PostgreSQL, including normalization, NULL handling, and making psql more useful.