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


--

With Regards,
Prabhat Kumar Sahu
EnterpriseDB: http://www.enterprisedb.com

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: WAL usage calculation patch
Следующее
От: Nicola Contu
Дата:
Сообщение: Re: EINTR while resizing dsm segment.