Sanjeev Singh – Medium

Feb 24

How to Monitor AWS RDS Instances for Pending Maintenance Actions with Bash Scripting

How to Monitor AWS RDS Instances for Pending Maintenance Actions with Bash Scripting As cloud infrastructure grows more complex and dynamic, observability tools like Datadog have become increasingly essential. However, not all organizations have access to such tools, making it difficult to monitor and manage large numbers of databases effectively. This is where Bash scripting comes in handy. With Bash, you can automate…

2 min read

Feb 5

Optimizing PostgreSQL Performance with Visibility Map: Understanding, Monitoring and Fine-tuning

Optimizing PostgreSQL Performance with Visibility Map: Understanding, Monitoring and Fine-tuning What is a Visibility Map in PostgreSQL? A visibility map in PostgreSQL is a data structure that helps the database to determine which pages of a table are potentially visible to concurrent transactions. …

2 min read

Jan 28

The Resilience of CockroachDB: A Distributed SQL Database Built to Survive

The Resilience of CockroachDB: A Distributed SQL Database Built to Survive Cockroach Labs, the company behind the development and maintenance of the distributed SQL database, was founded by former Google engineers Spencer Kimball, Peter Mattis, and Ben Darnell in 2015. Some aspects of CockroachDB were inspired by Spanner, Google’s globally distributed database offering. …

4 min read

Dec 30, 2022

PostgreSQL: Commonly used indexes and their possible use-cases

B-tree index: B-tree indexes are the most common type of index in PostgreSQL, and they are generally well-suited for indexing data types that have a large number of distinct values, such as integers, dates, or strings. …

4 min read

Dec 29, 2022

Factors to consider when determining which type of index to choose in PostgreSQL:

Data type: Different index types are better suited for different data types. For example, B-tree indexes are generally well-suited for indexing data types that have a smaller number of distinct values, such as integers, dates, or strings. Gin indexes, on the other hand, are better suited for indexing data types…

4 min read