Shailesh Kumar MishrainDev GeniusWant powerful defense against Ransomware attacks?Note: This can be implemented for on-prem based backup also using storage gateway services.Aug 22Aug 22
Shailesh Kumar MishrainDev GeniusWhen PostgreSQL Query Planner Goes Rogue: A Deep Dive into Query OptimizationAre you a DBA, PostgreSQL expert, RDS/Aurora specialist, or a solution architect grappling with sudden query slowdowns? Discover how…Jul 31Jul 31
Shailesh Kumar MishraGenAI and its carbon footprints: Practical approach to address itDuring a quiet evening at home, my son Shikhar, a schoolboy studying n 10th standard diligently working on his holiday homework, posed a…Jun 9Jun 9
Shailesh Kumar MishraOptimise INSERT, UPDATE and DELETE in PostgreSQL using best indexing strategyThere are numerous ways to optimize SQL performance in any database. In this article, we will focus on scenarios where your tables are…May 24May 24
Shailesh Kumar MishraConsidering UUIDs as Primary Keys in Database Tables?In modern database design, the choice of primary keys plays a crucial role in ensuring efficient data management. While Universally Unique…Apr 1Apr 1
Shailesh Kumar MishraCan cache layer slow down databases?The integration of a cache layer, such as Redis, into an application with high read traffic can significantly enhance performance. However…Jan 8Jan 8
Shailesh Kumar MishraTracking data dependencies in PostgreSQLTracking data dependencies in PostgreSQL tables is an essential aspect of managing and analyzing data relationships within a database. This…Oct 29, 2023Oct 29, 2023
Shailesh Kumar MishraOptimise PostgreSQL queries with work_memWelcome to this deep dive into PostgreSQL performance tuning, where we’ll unravel the mysteries of `work_mem` and explore how you can…Oct 25, 20231Oct 25, 20231
Shailesh Kumar MishraFind slow queries in PostgreSQLSlow queries can have a significant impact on the performance of your PostgreSQL database. By identifying and optimizing slow queries, you…Oct 8, 2023Oct 8, 2023
Shailesh Kumar MishraMigrating PostgreSQL database ?This blog explains key concepts on what are the various checks and validation required before PosgreSQL database can be migrated. Here we…Jun 26, 2023Jun 26, 2023