postgres=# alter system set max_active_global_temporary_table =1; ALTER SYSTEM
--restart the server (./pg_ctl -D data restart)
--create global temp table
postgres=# create global temp table ccc1 (c int); CREATE TABLE
--Try to Create another global temp table
postgres=# create global temp table ccc2 (c int); WARNING: relfilenode 13589/1663/19063 not exist in gtt shared hash when forget ERROR: out of shared memory HINT: You might need to increase max_active_gtt.
postgres=# show max_active_gtt; ERROR: unrecognized configuration parameter "max_active_gtt" postgres=# postgres=# show max_active_global_temporary_table ; max_active_global_temporary_table ----------------------------------- 1 (1 row)
postgres=#
I cannot find "max_active_gtt" GUC . I think you are referring to "max_active_global_temporary_table" here ?
You're right.
Fixed in global_temporary_table_v17-pg13.patch
Wenjing
also , would be great if we can make this error message user friendly like - "max connection reached" rather than memory error