DEV Community

#postgres

Posts on tips and tricks, using and learning about PostgreSQL for database development and analysis.

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
Rebuilding the Cerebras Knowledge Base: adding hybrid search
faridgnank02 profile

Rebuilding the Cerebras Knowledge Base: adding hybrid search

#rag #vectordatabase #postgres #ai
Comments
6 min read
Rebuilding the Cerebras Knowledge Base: the naive vector baseline
faridgnank02 profile

Rebuilding the Cerebras Knowledge Base: the naive vector baseline

#rag #vectordatabase #postgres #ai
Comments
5 min read
Incremental Backup Using pg_basebackup in PostgreSQL 18
vahidusefzadeh profile

Incremental Backup Using pg_basebackup in PostgreSQL 18

#postgres #database #linux #ai
1
Comments
7 min read
Postgres RLS multi-tenancy: two leaks that survive correct policies
wenceslaudev profile

Postgres RLS multi-tenancy: two leaks that survive correct policies

#postgres #database #security #webdev
Comments 2
8 min read
Five bugs AI wrote for me that never threw an error
igor_potapenko profile

Five bugs AI wrote for me that never threw an error

#ai #webdev #testing #postgres
Comments
6 min read
Deterministic checks for AI-written migrations
bolvrk profile

Deterministic checks for AI-written migrations

#aiworkflows #postgres #migrations
9
Comments
4 min read
Why ADD COLUMN NOT NULL fails on a full table, and the migration that does not
bolvrk profile

Why ADD COLUMN NOT NULL fails on a full table, and the migration that does not

#postgres #migrations #notnull
10
Comments
3 min read
Replace the Heuristic With a Boundary: Rebuilding a Leave Table as an Append-Only Ledger
dbartalos profile

Replace the Heuristic With a Boundary: Rebuilding a Leave Table as an Append-Only Ledger

#postgres #architecture #database #datamigration
Comments
9 min read
What is Information Schema in PostgreSQL?
hrrydgls profile

What is Information Schema in PostgreSQL?

#database #postgres
Comments
2 min read
CREATE INDEX CONCURRENTLY is not free, and half the time you do not need it
bolvrk profile

CREATE INDEX CONCURRENTLY is not free, and half the time you do not need it

#postgres #indexes #locks #data
7
Comments
4 min read
Adding a foreign key to a big table without locking both of them
bolvrk profile

Adding a foreign key to a big table without locking both of them

#postgres #migrations #foreignkeys #locks
7
Comments
3 min read
One line stops a migration from taking down production. Almost nobody adds it.
bolvrk profile

One line stops a migration from taking down production. Almost nobody adds it.

#postgres #locks #migrations #incidents
6
Comments
4 min read
Visual Search on pgvector + Gemini: Detect, Crop, Embed, Rank (and the Averaging Bug That Broke Exact Match)
sahib_alizada profile

Visual Search on pgvector + Gemini: Detect, Crop, Embed, Rank (and the Averaging Bug That Broke Exact Match)

#ai #postgres #python #machinelearning
Comments
8 min read
Postgres LISTEN/NOTIFY in Production: Safe Reconnects & SSE
engineering profile

Postgres LISTEN/NOTIFY in Production: Safe Reconnects & SSE

#postgres
1
Comments 1
7 min read
Database Index: Why Queries Become Slow as Data Grows
lukman-ss profile

Database Index: Why Queries Become Slow as Data Grows

#database #postgres #sql #backend
5
Comments
3 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.