Cheat Sheet logoCheat Sheet Today
PostgreSQL Performance Cheat Sheet/Set LOCAL work_mem

Increase work_mem for the current transaction only.

Back to sheetBrowse commands
Sign in to save
Section: Planner Settings and Statistics

Set LOCAL work_mem

sql
sql
SET LOCAL work_mem = '256MB';
Explanation

See summary for usage details.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing Planner Settings and Statistics
Show work_mem
Inspect a setting that affects sort and hash memory usage.
OpenIn sheetsqlsame section
Show effective_cache_size
Inspect a planner estimate of OS cache availability.
OpenIn sheetsqlsame section
Show random_page_cost
Inspect a cost parameter that influences index-vs-seqscan decisions.
OpenIn sheetsqlsame section
Disable seqscan for investigation
Temporarily discourage sequential scans while investigating plans.
OpenIn sheetsqlsame section
Inspect pg_stats
Inspect statistics the planner uses.
OpenIn sheetsqlsame section
Show autovacuum setting
Check whether autovacuum is enabled.
OpenIn sheetsql1 tag match