Sumeet ShuklaNormalization in OLTP vs. OLAP: Striking the BalanceData is the lifeblood of modern organizations, driving every aspect of operations and strategic decision-making. But storing and accessing…Dec 20, 2023Dec 20, 2023
Sumeet ShuklaThe Quiet Triumph: Signs You’ve Truly Solved a Database Administration ProblemDatabase administrators (DBAs) are the unsung heroes of the digital world. They toil away in the background, ensuring the smooth flow of…Dec 16, 2023Dec 16, 2023
Sumeet ShuklaPostgreSQL ArchitecturePostgreSQL instance consists of set of Process and Memory. PostgreSQL uses a simple “process per-user” client/server model. The major…Jan 12, 2023Jan 12, 2023
Sumeet ShuklaInstall and Configure pgBadger for PostgreSQL on LinuxYes, one of the most important things is knowing how the databases are used. Indeed if we know what are the slowest queries, the most…Jan 12, 20231Jan 12, 20231
Sumeet Shuklaintalabat TechSolving AWS Aurora RDS load balancing problem with pgPool-IIDNS-based load balancing has been around for a long time. AWS Aurora relies on this technology for load balancing the read replicas behind…Sep 30, 20204Sep 30, 20204