Performance Tuning
Everything on SkillVeris tagged Performance Tuning — collected across the glossary, study notes, blog, and cheat sheets.
12 resources across 2 libraries
Study Notes(1)
Interview Questions(11)
What is Database Partitioning?
Database partitioning is splitting a large table into smaller, more manageable pieces called partitions, while the table is still queried as one logical unit.
What is Denormalization in Database?
Denormalization is the deliberate process of combining data from multiple related tables back into fewer, wider tables to reduce joins and speed up read querie…
What Does EXPLAIN ANALYZE Do?
EXPLAIN ANALYZE actually runs the query and returns the real execution plan annotated with true measured timings and row counts for every operator, unlike plai…
What Causes Replication Lag and How Do You Reduce It?
Replication lag is the delay between a write committing on the primary and that same write becoming visible on a replica, and it is typically caused by network…
What is Checkpointing in a Database and Why is it Needed?
Checkpointing is the process of periodically flushing all dirty (modified but unwritten) data pages from memory to disk and recording a marker in the write-ahe…
How Do You Tune Autovacuum in PostgreSQL?
Tuning autovacuum means adjusting how aggressively and how frequently PostgreSQL's background autovacuum workers scan and clean each table, primarily by loweri…
How Do You Tune a Database Connection Pool?
A connection pool is tuned by sizing it to the database's actual concurrency capacity rather than the application's thread count, then adjusting timeouts and e…
How Do You Tune Database Connection Timeouts?
Tuning connection timeouts means setting separate limits for connection acquisition, query execution, and idle connections so that a slow dependency fails fast…
What is Write Amplification and Why Does it Matter?
Write amplification is the ratio between the amount of data actually written to physical storage and the amount of data the application logically intended to w…
What is DVFS (Dynamic Voltage and Frequency Scaling)?
DVFS is a power-management technique where the OS or firmware dynamically lowers or raises a CPU's clock frequency and supply voltage based on current workload…
What is Write Amplification and Why Does It Matter for Storage Engines?
Write amplification is the phenomenon where a single logical write from an application triggers a much larger amount of physical data actually written to durab…