> 2020年3月5日 下午10:19，tushar <tushar.ah...@enterprisedb.com> 写道： > > 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 ? > 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 > > -- > regards,tushar > EnterpriseDB https://www.enterprisedb.com/ <https://www.enterprisedb.com/> > The Enterprise PostgreSQL Company
