Re: [Proposal] Global temporary tables

Wenjing Zeng <wjzeng2012@gmail.com>

From: wenjing <wjzeng2012@gmail.com>

To: Ming Li <mli@apache.org>

Cc: wenjing@gmail.com, Dilip Kumar <dilipbalaut@gmail.com>, shawn wang <shawn.wang.pg@gmail.com>, Pavel Stehule <pavel.stehule@gmail.com>, Andrew Dunstan <andrew@dunslane.net>, 曾文旌 <wenjing.zwj@alibaba-inc.com>, Robert Haas <robertmhaas@gmail.com>, Prabhat Sahu <prabhat.sahu@enterprisedb.com>, tushar <tushar.ahuja@enterprisedb.com>, Tomas Vondra <tomas.vondra@2ndquadrant.com>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>

Date: 2021-07-22T09:40:49Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

PageAddItemExtended(): Add LP_UNUSED assertion.
- 30aaab26e521 14.0 cited
Remove temporary files after backend crash
- cd91de0d1795 14.0 cited
Fix comment in indexing.c
- 9fd2952cf492 14.0 cited
Fix failure to ignore leftover temp tables after a server crash.
- 6919b7e32947 9.3.0 cited

Attachments

0002-gtt-v51-regress.patch (application/octet-stream) patch v51-0002
0003-gtt-v51-doc.patch (application/octet-stream) patch v51-0003
0001-gtt-v51.patch (application/octet-stream) patch v51-0001

Ming Li <mli@apache.org> 于2021年7月14日周三 上午10:56写道：

> Hi Wenjing,
>
> Some suggestions may help:
>
> 1) It seems that no test case covers the below scenario: 2 sessions attach
> the same gtt, and insert/update/select concurrently. It is better to use
> the test framework in src/test/isolation like the code changes in
> https://commitfest.postgresql.org/24/2233/.
>

Thanks for pointing this out, I am working on this issue.


>
> 2) CREATE GLOBAL TEMP SEQUENCE also need to be supported
> in src/bin/psql/tab-complete.c
>
It has been fixed in V51, please check

Regards,
wenjing

>
>
> On Wed, Jul 14, 2021 at 10:36 AM wenjing <wjzeng2012@gmail.com> wrote:
>
>> Rebase code based on the latest version.
>>
>> Regards,
>> wenjing
>>
>>