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.
How I cut Django indexing from 23 minutes to 11 minutes with one SQL change

How I cut Django indexing from 23 minutes to 11 minutes with one SQL change

1
Comments
1 min read
pgvector + Ollama Setup

pgvector + Ollama Setup

Comments
4 min read
Securing PostgreSQL, in the order an attacker would try things

Securing PostgreSQL, in the order an attacker would try things

2
Comments
7 min read
PostgreSQL Plan Signatures: Quick Reference

PostgreSQL Plan Signatures: Quick Reference

Comments
7 min read
Indexing every WHERE column is not PostgreSQL optimization

Indexing every WHERE column is not PostgreSQL optimization

1
Comments
1 min read
Provisioning PostgresSQL RDBMS on AWS with Terraform

Provisioning PostgresSQL RDBMS on AWS with Terraform

Comments
5 min read
Why Supavisor 1.0 Is Written in Elixir (And Why That's Actually a Brilliant Move)

Why Supavisor 1.0 Is Written in Elixir (And Why That's Actually a Brilliant Move)

Comments
9 min read
pgvector with Node.js: Build Semantic Search on PostgreSQL

pgvector with Node.js: Build Semantic Search on PostgreSQL

Comments
4 min read
Tracing a 2s Latency Spike to a Single SQL Query

Tracing a 2s Latency Spike to a Single SQL Query

Comments
2 min read
Indexing & Query Optimization: How to Make Your Database Fast

Indexing & Query Optimization: How to Make Your Database Fast

Comments
3 min read
REDB inside, part 1.1 — why the same 13 tables stay fast no matter how many classes you throw at them

REDB inside, part 1.1 — why the same 13 tables stay fast no matter how many classes you throw at them

2
Comments 8
20 min read
Build a URL shortener with Fitz: HTTP + Postgres + auth in 30 minutes

Build a URL shortener with Fitz: HTTP + Postgres + auth in 30 minutes

1
Comments
11 min read
ConstruĂ­ tu primera API con Fitz: un acortador de URLs con Postgres y auth en 30 minutos

ConstruĂ­ tu primera API con Fitz: un acortador de URLs con Postgres y auth en 30 minutos

1
Comments
12 min read
GIN: Understanding PostgreSQL's Inverted Index and Its Limitations

GIN: Understanding PostgreSQL's Inverted Index and Its Limitations

1
Comments
5 min read
RUM—Storing More in the Index

RUM—Storing More in the Index

Comments
6 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.