Re: [Proposal] Global temporary tables
曾文旌 (义从) <wenjing.zwj@alibaba-inc.com>
From: 曾文旌 <wenjing.zwj@alibaba-inc.com>
To: Erik Rijkers <er@xs4all.nl>
Cc: Pavel Stehule <pavel.stehule@gmail.com>, Robert Haas <robertmhaas@gmail.com>, Prabhat Sahu <prabhat.sahu@enterprisedb.com>, tushar <tushar.ahuja@enterprisedb.com>, Tomas Vondra <tomas.vondra@2ndquadrant.com>, Konstantin Knizhnik <k.knizhnik@postgrespro.ru>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>, "蔡松露(子嘉)" <zijia@taobao.com>, "Cai, Le" <le.cai@alibaba-inc.com>, "萧少聪(铁庵)" <shaocong.xsc@alibaba-inc.com>
Date: 2020-04-09T13:28:25Z
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
- global_temporary_table_v25-pg13.patch (application/octet-stream) patch v25
- (unnamed) (text/plain)
> 2020年4月7日 下午6:40,Erik Rijkers <er@xs4all.nl> 写道: > > On 2020-04-07 10:57, 曾文旌 wrote: > >> [global_temporary_table_v24-pg13.patch ] > > Hi, > > With gcc 9.3.0 (debian stretch), I see some low-key protests during the build: > > index.c: In function ‘index_drop’: > index.c:2051:8: warning: variable ‘rel_persistence’ set but not used [-Wunused-but-set-variable] > 2051 | char rel_persistence; > | ^~~~~~~~~~~~~~~ > storage_gtt.c: In function ‘gtt_force_enable_index’: > storage_gtt.c:1252:6: warning: unused variable ‘indexOid’ [-Wunused-variable] > 1252 | Oid indexOid = RelationGetRelid(index); > | ^~~~~~~~ > cluster.c: In function ‘copy_table_data’: > cluster.c:780:2: warning: this ‘if’ clause does not guard... [-Wmisleading-indentation] > 780 | if (RELATION_IS_GLOBAL_TEMP(OldHeap)); > | ^~ > cluster.c:781:3: note: ...this statement, but the latter is misleadingly indented as if it were guarded by the ‘if’ > 781 | is_gtt = true; > | ^~~~~~ > Part of the problem is that some variables are only used by assert statements, and I fixed those alarms. Please provide your configue parameter, and I will verify it again. Wenjing