Shiv IyerProshiviyer.hashnode.dev·Apr 29, 2024Optimizing Query Latency in PostgreSQL: Understanding Process-Based Architecture and Performance Tuning TipsIn PostgreSQL, the architecture does not use threads for client connections but instead utilizes a multi-process model where each client connection is handled by an individual server process. This approach has implications for how performance and que...Discuss·10 likes·158 readsPostgreSQL
Shiv IyerProshiviyer.hashnode.dev·Apr 28, 2024How to Use the CAST Operator for Data Type Conversion in ClickHouseIn ClickHouse, the CAST operator is used to convert a value from one data type to another. This can be particularly useful in scenarios where you need to ensure that data types match between different parts of your queries, such as when comparing col...DiscussOLAP
Shiv IyerProshiviyer.hashnode.dev·Apr 17, 2024Correlating Worst-Performing Queries with Missing IndexesIntroduction In the world of database performance optimization, identifying and resolving performance bottlenecks is crucial. One common cause of slow query execution is the absence of proper indexes. In this blog post, we will explore the relationsh...Discuss·58 readsPostgreSQL
Shiv IyerProshiviyer.hashnode.dev·Apr 12, 2024Lifecycle of a query in PostgreSQLIntroduction In the world of databases, PostgreSQL stands out as one of the most powerful and reliable open-source relational database management systems. It offers a wide range of features and functionalities, including a well-defined lifecycle for ...Discuss·7 likes·149 readsPostgreSQL
Shiv Iyerfor#AzureSQL #SQLServer #Azure #SQLazuresql.hashnode.dev·Apr 11, 2024Best Practices: Why Changing SET Options Within a Batch in SQL Server is DiscouragedChanging SET options within a batch in SQL Server can lead to unexpected behavior, performance issues, and compatibility problems. It's strongly recommended to avoid altering SET options mid-batch for several reasons: 1. Plan Caching and Recompilatio...DiscussSQL
Shiv Iyerfor#AzureSQL #SQLServer #Azure #SQLazuresql.hashnode.dev·Apr 4, 2024How to Boost Azure SQL Performance with Effective Optimization TechniquesOptimization preparation in Azure SQL involves a series of steps aimed at enhancing the performance of your database by ensuring it is configured correctly, the schema is optimized, queries are efficient, and resources are appropriately scaled. Imple...DiscussSQL
Shiv Iyerfor#AzureSQL #SQLServer #Azure #SQLazuresql.hashnode.dev·Mar 25, 2024Enhancing Performance in Azure SQL: Understanding NULL Values' Effects on Indexes and JOINsIn Azure SQL Database, as in other relational database systems, handling NULL values in columns that are indexed or involved in JOIN operations can have specific implications on index performance and the execution plans generated by the SQL Server qu...DiscussSQL
Shiv Iyerfor#AzureSQL #SQLServer #Azure #SQLazuresql.hashnode.dev·Mar 15, 2024Setting Up a Starting Point for Analyzing Wait Statistics in Azure SQL to Improve Performance TroubleshootingBuilding a baseline for Wait Statistics analysis is a crucial step in performance troubleshooting for Azure SQL databases. Wait Statistics are a valuable source of information for identifying bottlenecks and understanding what a database is waiting o...Discuss·53 readsSQL
Shiv IyerProshiviyer.hashnode.dev·Mar 12, 2024How can you change the data type of the column in ClickHouse?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...Discuss·36 readsClickHouse
Shiv IyerProshiviyer.hashnode.dev·Mar 9, 2024How can you identify and fix bloated tables and indexes in PostgreSQL 16?Identifying and fixing bloated tables and indexes in PostgreSQL is crucial for maintaining database performance and efficient use of disk space. Bloat occurs due to PostgreSQL's MVCC (Multi-Version Concurrency Control) implementation, where old versi...Discuss·249 readsPostgreSQL