| From: | 曾文旌 <wenjing(dot)zwj(at)alibaba-inc(dot)com> |
|---|---|
| To: | Prabhat Sahu <prabhat(dot)sahu(at)enterprisedb(dot)com> |
| Cc: | tushar <tushar(dot)ahuja(at)enterprisedb(dot)com>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, Konstantin Knizhnik <k(dot)knizhnik(at)postgrespro(dot)ru>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, "蔡松露(子嘉)" <zijia(at)taobao(dot)com>, "Cai, Le" <le(dot)cai(at)alibaba-inc(dot)com>, "萧少聪(铁庵)" <shaocong(dot)xsc(at)alibaba-inc(dot)com> |
| Subject: | Re: [Proposal] Global temporary tables |
| Date: | 2020-04-08 08:18:27 |
| Message-ID: | A77FCEA7-FCD9-43D9-969D-7E1EAD83F9BF@alibaba-inc.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> 2020年4月7日 下午6:22，Prabhat Sahu <prabhat(dot)sahu(at)enterprisedb(dot)com> 写道：
>
> Thanks for review.
> This parameter should support all types of writing of the bool type like parameter autovacuum_enabled.
> So I fixed in global_temporary_table_v24-pg13.patch.
>
> Thank you Wenjing for the new patch with the fix and the "VACUUM FULL GTT" support.
> I have verified the above issue now its resolved.
>
> Please check the below findings on VACUUM FULL.
>
> postgres=# create global temporary table gtt(c1 int) on commit preserve rows;
> CREATE TABLE
> postgres=# vacuum FULL ;
> WARNING: global temp table oldest FrozenXid is far in the past
> HINT: please truncate them or kill those sessions that use them.
> VACUUM
This is expected,
This represents that the GTT FrozenXid is the oldest in the entire db, and dba should vacuum the GTT if he want to push the db datfrozenxid.
Also he can use function pg_list_gtt_relfrozenxids() to check which session has "too old” data and truncate them or kill the sessions.
>
> --
> With Regards,
> Prabhat Kumar Sahu
> EnterpriseDB: http://www.enterprisedb.com <http://www.enterprisedb.com/>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Masahiko Sawada | 2020-04-08 08:19:19 | Re: pg_stat_statements issue with parallel maintenance (Was Re: WAL usage calculation patch) |
| Previous Message | Kyotaro Horiguchi | 2020-04-08 08:02:22 | Re: [HACKERS] Restricting maximum keep segments by repslots |