Forem

# 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.
Schema Design with Supabase: Partitioning and Normalization

Schema Design with Supabase: Partitioning and Normalization

Comments
5 min read
Effortless PostgreSQL Environment in Docker For Windows
Cover image for Effortless PostgreSQL Environment in Docker For Windows

Effortless PostgreSQL Environment in Docker For Windows

Comments
5 min read
How We Used DBtune to Cut Our Postgres Query Time by 50% on AWS RDS
Cover image for How We Used DBtune to Cut Our Postgres Query Time by 50% on AWS RDS

How We Used DBtune to Cut Our Postgres Query Time by 50% on AWS RDS

3
Comments
9 min read
Connecting Power BI to PostgreSQL (Aiven & Localhost): A Simple Step-by-Step Guide

Connecting Power BI to PostgreSQL (Aiven & Localhost): A Simple Step-by-Step Guide

Comments
2 min read
Building an AI Code Review Swarm with Gemini & Tiger Cloud Postgres

Building an AI Code Review Swarm with Gemini & Tiger Cloud Postgres

Comments
2 min read
Why I chose Postgres (TimescaleDB) over ClickHouse for storing 10M+ logs
Cover image for Why I chose Postgres (TimescaleDB) over ClickHouse for storing 10M+ logs

Why I chose Postgres (TimescaleDB) over ClickHouse for storing 10M+ logs

3
Comments
3 min read
🗄️ Build an MCP Server for PostgreSQL: Query Your Database with Claude & Any AI ClientHappy building

🗄️ Build an MCP Server for PostgreSQL: Query Your Database with Claude & Any AI ClientHappy building

2
Comments 1
4 min read
How to Connect PostgreSQL to Power BI Using Local PostgreSQL and Aiven

How to Connect PostgreSQL to Power BI Using Local PostgreSQL and Aiven

Comments
3 min read
How to load test PostgreSQL database and not miss anything
Cover image for How to load test PostgreSQL database and not miss anything

How to load test PostgreSQL database and not miss anything

3
Comments
14 min read
Recognition of the Winners of the Agentic Postgres Challenge with Tiger Data
Cover image for Recognition of the Winners of the Agentic Postgres Challenge with Tiger Data

Recognition of the Winners of the Agentic Postgres Challenge with Tiger Data

5
Comments 2
2 min read
Vector Search is not enough: Why I added BM25 (Hybrid Search) to my AI Memory Server
Cover image for Vector Search is not enough: Why I added BM25 (Hybrid Search) to my AI Memory Server

Vector Search is not enough: Why I added BM25 (Hybrid Search) to my AI Memory Server

Comments
2 min read
Reconocimiento a los ganadores del Agentic Postgres Challenge con Tiger Data
Cover image for Reconocimiento a los ganadores del Agentic Postgres Challenge con Tiger Data

Reconocimiento a los ganadores del Agentic Postgres Challenge con Tiger Data

Comments 1
2 min read
Analyzing psqlrc settings on GitHub: How PostgreSQL engineers configure PostgreSQL
Cover image for Analyzing psqlrc settings on GitHub: How PostgreSQL engineers configure PostgreSQL

Analyzing psqlrc settings on GitHub: How PostgreSQL engineers configure PostgreSQL

4
Comments
17 min read
Under the Hood: Building a Hybrid Search Engine for AI Memory (Node.js + pgvector)
Cover image for Under the Hood: Building a Hybrid Search Engine for AI Memory (Node.js + pgvector)

Under the Hood: Building a Hybrid Search Engine for AI Memory (Node.js + pgvector)

Comments 2
2 min read
[MyNextHome] Simple Backend Server (Supabase) with Express JS

[MyNextHome] Simple Backend Server (Supabase) with Express JS

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