Tag:databases

All the articles with the tag "databases".

• 05. Database Sharding

  Posted on:June 17, 2023 |  at 10:00 AM

  Database sharding is a technique for dividing a large database into smaller chunks or shards. This can improve performance and scalability. Database sharding comes with its own pros and cons which we will discuss in this article.

• 01. Understanding database storage

  Posted on:June 15, 2023 |  at 10:00 AM

  A prologue to understanding how data is structured and organized in the databases before we delve into advanced topics. Database optimizes the storage of data in various files and data structures to ensure that queries run most effectively. In this article, we will see how PostgreSQL stores data. The concept is very similar to other RDBMS like MySQL.

• 03. Understanding EXPLAIN & ANALYZE

  Posted on:June 16, 2023 |  at 10:00 AM

  In this article, we will see how to use EXPLAIN and ANALYZE and different types of scans done by PostgreSQL.