Increase performance of alter tables or any other expensive operations by increasing WORK_MEM parameter for current session in PostgreSQL

posgresql-lightspeed-alter-table.sql

BEGIN;
LOCK TABLE ... IN SHARE MODE;
SET LOCAL WORK_MEM = '256MB';
ALTER TABLE ...;
COMMIT;