Re: [Proposal] Global temporary tables
| От | Prabhat Sahu |
|---|---|
| Тема | Re: [Proposal] Global temporary tables |
| Дата | |
| Msg-id | CANEvxPqXD_6W4Va_drLuBd9M3oDSFionxy63E5MnYeQvNr5BCg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: [Proposal] Global temporary tables (曾文旌 <wenjing.zwj@alibaba-inc.com>) |
| Ответы |
Re: [Proposal] Global temporary tables
|
| Список | pgsql-hackers |
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
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
With Regards,
Prabhat Kumar Sahu
EnterpriseDB: http://www.enterprisedb.com
В списке pgsql-hackers по дате отправления: