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
Shailesh Kumar MishrainGoogle Cloud - CommunityTroubleshooting Google Cloud SQL “Misleading” ERROR during restoreGoogle Cloud SQL Misleading ERROR: (gcloud.sql.backups.restore) HTTPError 403: The client is not authorized to make this request.Aug 14, 2022Aug 14, 2022
Shailesh Kumar MishrainGoogle Cloud - CommunitySecure Google Cloud SQL Instances using Private IP: Gotchas & troubleshootingCloud SQL is Google Cloud’s fully managed relational database service for MySQL, PostgreSQL and SQL Server. This blog is for you, if you…Feb 14, 20222Feb 14, 20222