by Ninad Shah | Apr 12, 2024 | Insight for DBAs, MySQL, PostgreSQL
This short write-up focuses on a different transaction control behavior of databases. Though this is not unusual, I decided to write an article on rolling back transactions to a particular point. I selected this topic because I found many people are not aware of this... by Ninad Shah | Feb 2, 2024 | Insight for DBAs, MySQL, PostgreSQL
This blog was originally published in June of 2023 and was updated in February of 2024.On occasion, DBAs come across segmentation fault issues while executing some queries. However, this is one of the least-explored topics to date. I tried to search for details... by Ninad Shah | Jan 25, 2024 | Insight for DBAs, Insight for Developers, PostgreSQL
In every database product, sequential scans or full table scans are often resource consuming, so almost all the developers and DBAs see such scans as a performance killer. In my opinion, this is a false perception or biased view. In many cases, sequential scans are... by Ninad Shah | Jan 17, 2023 | Insight for DBAs, PostgreSQL
This blog is in continuation of my previous blog on the basic understanding of corruption with the subject line The Ultimate Guide to Database Corruption: Part 1 – An Overview. If you have not already gone through it, I encourage you to read it to understand... by Ninad Shah | Jun 30, 2022 | Database Trends, Insight for DBAs, Open Source
Though I am writing this post being a PostgreSQL DBA, this page can be read by anyone because the concept of corruption is the same in every database.After reading this blog post, one should understand what database corruption is and how it may occur.Being DBAs,...