psql -d postgres -c "ALTER SYSTEM SET work_mem = '64MB';"

Category: Databases & SQL

psql -d postgres -c "ALTER SYSTEM SET work_mem = '64MB';"

Set work_mem cluster-wide

Writes the setting into postgresql.auto.conf, which overrides postgresql.conf, so no file editing is needed. Requires superuser. Most parameters apply after a reload, not instantly. ALTER SYSTEM RESET removes the override.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.