© 2026 Hashnode
OLTP means Online Transaction Processing and OLAP means Online Analytical Processing. OLTP (Online Transaction Processing) OLTP databases supports the day to day transactions. It’s a scenario database for storing day to day sales, people coming in, l...

Henlo frens We discussed till LSM-tree in the last blog, had to break it down into 2 cause this chapter has too much information. Many databases use B-trees, it has become the standard. LSM-tree and B-tree both keep the key value pair sorted, but bot...

Changing the data type of a column in ClickHouse, like in many database systems, is a sensitive operation and needs careful planning, especially in a production environment. Directly altering a column's data type isn't supported as a single operation...

Restricting new connections to a PostgreSQL database is essential during maintenance periods or to manage system resources effectively. Here are several methods to achieve this: 1. Modify max_connections Setting The max_connections setting in the pos...
