On 3/3/20 2:10 PM, 曾文旌(义从) wrote:
I fixed in global_temporary_table_v16-pg13.patch.
Please refer this scenario -
--Connect to psql -
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 ?
also , would be great if we can make this error message user friendly like - "max connection reached" rather than memory error
--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company