Re: [Proposal] Global temporary tables

> 2020年3月5日 下午10:19，tushar <tushar(dot)ahuja(at)enterprisedb(dot)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