POSTGRESQL KNOWLEDGE
A Technical Publication Built Around PostgreSQL, Open Source Community, and Real Database Engineering Experiences
Let’s Discover the Power of PostgreSQL Togehter!
Latest Articles and News
Explore our newest technical articles, implementation guides, database insights, and community news!
PGConf.dev 2026: Why It Remains My Favorite PostgreSQL Conference
About PGConf.dev PGConf.dev is an annual developer event focused entirely on contributing to the PostgreSQL ecosystem, including core software development and community building. It serves as a primary hub for[…]
Read more
Understanding PostgreSQL REPACK Through repack.c
REPACK is a new PostgreSQL 19 feature for physically compacting a table by rewriting it into new storage. Like VACUUM, it deals with the space left behind by dead tuples,[…]
Read more
Understanding ALTER TABLE Behavior on Partitioned Tables in PostgreSQL
Partitioned tables are a core PostgreSQL feature, but one area still causes regular confusion—even for experienced users: How exactly does ALTER TABLE behave when partitions are involved? Does an operation[…]
Read moreFeatured Categories
PostgreSQL
Explore tutorials, performance optimization, database internals, security, replication, extensions, and best practices for PostgreSQL development and administration.Explore tutorials, performance optimization, database internals, security, replication, extensions, and best practices for PostgreSQL development and administration.
Pgpool-II
Learn how to deploy, configure, and manage Pgpool-II for connection pooling, load balancing, high availability, and scalable PostgreSQL clusters.Learn how to deploy, configure, and manage Pgpool-II for connection pooling, load balancing, high availability, and scalable PostgreSQL clusters.
Vacuum
Understand how PostgreSQL reclaims storage, prevents transaction ID wraparound, and maintains query performance through effective VACUUM strategies.Understand how PostgreSQL reclaims storage, prevents transaction ID wraparound, and maintains query performance through effective VACUUM strategies.