#postgres — Carlos Rodrigues

GraphRAG – how agents can leverage structured knowledge and stay on track: #AI for dummies #6

By Carlos Rodrigues

15 min read

GraphRAG – how agents can leverage structured knowledge and stay on track: #AI for dummies #6

This article compares standard vector RAG with GraphRAG, explaining when global synthesis and multi-hop reasoning justify higher ingestion cost and latency. It then builds a PostgreSQL proof of concept using pgvector and Apache AGE with Docker and a Python retrieval pipeline.

2026-08-08 Read more

PostgreSQL – which configurations require a service restart

By Carlos Rodrigues

1 min read

PostgreSQL – which configurations require a service restart

To determine whether a PostgreSQL configuration change requires a service restart, query select name, context from pg_settings. If the context is postmaster, the setting requires a restart; otherwise a reload is sufficient.

2021-03-16 Read more