Re: [Proposal] Global temporary tables

2020年3月5日 下午10:19，tushar <tushar.ahuja@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 ?

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