May 2018
Intermediate to advanced
576 pages
30h 25m
English
SET work_mem = '16MB';
SET LOCAL work_mem = '16MB';
RESET work_mem;
RESET ALL;
The SET and RESET commands are SQL commands that can be issued from any interface. They apply only to PostgreSQL server parameters, but this does not mean that they affect the entire server. In fact, the parameters you can change with SET and RESET apply only to the current session. Also, note that there may be other parameters, such as JDBC ...