Increase performance of alter tables or any other expensive operations by increasing WORK_MEM parameter for current session in PostgreSQL
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