PAWAN SHARMA·May 10Building MySQLERDiagram: A Simple and Powerful ER Diagram Tool for MySQLWhen working with MySQL databases, one common challenge is understanding how tables are connected. As applications grow, databases become…
PAWAN SHARMA·Oct 15, 2025Introduction of Async IO in PG18PostgreSQL 18 introduces one major architectural change. ( Queue many reads — Process results as the data arrives from disk)
PAWAN SHARMA·Oct 13, 2025gen_random_uuid() vs UUIDv7 in PostgreSQL — a deep, practical comparisonUUIDs are used almost everywhere — as primary keys, correlation IDs, trace IDs, and object identifiers. PostgreSQL provides the…
PAWAN SHARMA·Sep 3, 2025Understanding PostgreSQL Buffer Cache: How Pages Move Between Memory, WAL, and DiskPostgreSQL is known for its robust architecture and reliability. A key part of this is how it manages data in memory before writing it to…
PAWAN SHARMA·Jul 31, 2025Efficient PostgreSQL Backups with pgBackRest: Tackling the Small Table ChallengeImagine a scenario where your system maintains thousands of tiny tables, each just a few megabytes in size. While each table may be…
PAWAN SHARMA·Jul 12, 2025PostgreSQL Replication Internals & High Availability with PatroniPostgreSQL has long been trusted for its reliability and data consistency. But building a production-grade high availability (HA) solution…
PAWAN SHARMA·Jul 10, 2025Reclaiming Space in PostgreSQL with pg_repack on macOSPostgreSQL doesn’t automatically reclaim disk space when rows are updated or deleted. Over time, tables can bloat , consuming disk and…
PAWAN SHARMA·Jun 4, 2025Install PG18 from the Source code on macOSStep 1: Download the PostgreSQL 18 package. https://www.postgresql.org/ftp/source/v18beta1/
PAWAN SHARMA·May 23, 2025Streaming Logical Changes with wal2json in a PostgreSQL Patroni ClusterIn this article, learn how to set up logical replication using the wal2json output plugin on a high-availability two-node PostgreSQL…