Instiq

3Performance tuning

Practice questions →Glossary →
  • 3.1Performance-related parameters

    Learn PostgreSQL's key performance parameters: memory-related shared_buffers, huge_pages, work_mem, maintenance_work_mem; WAL/checkpoint-related wal_level, fsync, checkpoint_timeout, max_wal_size, wal_keep_size, checkpoint_completion_target; lock-related deadlock_timeout; and how planner/statistics/resource-usage parameters interact.

  • 3.2Performing tuning

    Learn execution-plan and SQL-level tuning: the relationship between Index Only Scan and the Visibility Map, function indexes and partial indexes, partitioning, planner-control enable_* parameters (e.g. enable_seqscan), random_page_cost, hash_mem_multiplier, and non-disruptive operations via CREATE INDEX CONCURRENTLY, FILLFACTOR, and REINDEX.