Skip to content

Instantly share code, notes, and snippets.

@ufuk

ufuk/posgresql-lightspeed-alter-table.sql

Last active November 5, 2018 07:59
Show Gist options
  • Star 3 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ufuk/b8e03cece94101dbe0a6ec8fd4e31cdf to your computer and use it in GitHub Desktop.
Save ufuk/b8e03cece94101dbe0a6ec8fd4e31cdf to your computer and use it in GitHub Desktop.
Download ZIP
Increase performance of alter tables or any other expensive operations by increasing WORK_MEM parameter for current session in PostgreSQL
Raw
posgresql-lightspeed-alter-table.sql
BEGIN;
LOCK TABLE ... IN SHARE MODE;
SET LOCAL WORK_MEM = '256MB';
ALTER TABLE ...;
COMMIT;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment