Re: [Proposal] Global temporary tables

2022-02-28 Thread Wenjing Zeng
dme does a bit of that, > but not particularly well. Thank you for your review of the design and code. I'm always trying to improve it. If you are confused or need clarification on something, please point it out. > > > On 2022-02-25 14:26:47 +0800, Wenjing Zeng wrote: >>

Re: [Proposal] Global temporary tables

2022-02-28 Thread Wenjing Zeng
> 2022年2月27日 08:21,Justin Pryzby 写道: > > I read through this. > Find attached some language fixes. You should be able to apply each "fix" > patch on top of your own local branch with git am, and then squish them > together. Let me know if you have trouble with that. > > I think get_seqence_s

Re: [Proposal] Global temporary tables

2022-03-01 Thread Wenjing Zeng
> 2022年2月27日 12:13,Andres Freund 写道: > > Hi, > > On 2022-02-27 04:17:52 +0100, Pavel Stehule wrote: >>> You redirect stats from pg_class and pg_statistics to a local hash table. >>> This is pretty hairy :( > > As is I think the patch is architecturally completely unacceptable. Having > code

why does reindex invalidate relcache without modifying system tables

2021-12-27 Thread wenjing zeng
Hi Tom I would like to ask you about the details of index build. I found that in the index_update_stats function, i.e. the CREATE INDEX/REINDEX/Truncate INDEX process, relchche is invalidated whether the index information is updated. I want to know why you're did this The code is:

Re: why does reindex invalidate relcache without modifying system tables

2022-01-03 Thread wenjing zeng
> 2021年12月27日 23:54,Tom Lane 写道: > > wenjing zeng writes: >> I found that in the index_update_stats function, i.e. the CREATE >> INDEX/REINDEX/Truncate INDEX process, >> relchche is invalidated whether the index information is updated. I want to >> know

Re: [Proposal] Global temporary tables

2020-07-22 Thread wenjing zeng
> 2020年7月14日 下午10:28,Pavel Stehule 写道: > > > > pá 10. 7. 2020 v 11:04 odesílatel wenjing zeng <mailto:wjzeng2...@gmail.com>> napsal: > HI all > > I started using my personal email to respond to community issue. > > > >> 2020年7月7日 下午6:05

Re: [Proposal] Global temporary tables

2021-10-14 Thread wenjing zeng
> 2021年10月13日 13:08,Andrew Bille 写道: > > Thanks for the fix. It works for me. > > Now I'm exploring another crash related to GTT, but I need a few days to > present a simple repro. Be deeply grateful. Perhaps you can give the stack of problems so that you can start analyzing them as soon as

Re: Asynchronous and "direct" IO support for PostgreSQL.

2023-01-17 Thread Wenjing Zeng
> 2021年9月1日 13:56,Andres Freund 写道: > > Hi, > > Attached is an updated patch AIO series. The major changes are: > - rebased onto master (Andres) > - lots of progress on posix AIO backend (Thomas) > - lots of progress towards a windows native AIO implementation - not yet quite > merged (Thomas

Re: CREATE TABLE ( .. STORAGE ..)

2022-01-20 Thread wenjing zeng
HI For patch create_table_storage-v1 1 +ALTER opt_column ColId SET STORAGE name +opt_column_storage: + STORAGE ColId { $$ = $2; } Are they both set to name or ColId? Although they are the same. 2 For ColumnDef new member

Re: [PATCH] Implement INSERT SET syntax

2022-01-21 Thread wenjing zeng
Since this feature adds INSERT OVERRIDING SET syntax, it is recommended to add some related testcases. Regards Wenjing > 2021年9月22日 07:38,Rachel Heaton 写道: > >> On 4/23/20 8:04 PM, Gareth Palmer wrote: >>> >>> Thank you for the review, attached is v7 of the patch which should >>> apply co

Re: [Commitfest 2022-07] Begins Now

2022-07-15 Thread Wenjing Zeng
Hi Jacob Abort Global temporary table https://commitfest.postgresql.org/36/2349/# Please move the Global Temporary table to check next month, that is at 202208. I need more time to process the existing issue. Thanks Wenjing > 2022年7月9日 07:42,Jacob

Re: [Proposal] Global temporary tables

2021-07-29 Thread wenjing zeng
> 2021年7月28日 23:09,Tony Zhu 写道: > > Hi Wenjing > > would you please rebase the code? Thank you for your attention. According to the test, the latest pgmaster code can merge the latest patch and pass the test. https://www.travis-ci.com/github/wjzeng/postgres/builds

Re: [Proposal] Global temporary tables

2020-07-10 Thread wenjing zeng
HI all I started using my personal email to respond to community issue. > 2020年7月7日 下午6:05,Pavel Stehule 写道: > > Hi > > GTT Merge the latest PGMaster and resolves conflicts. > > > > I tested it and it looks fine. I think it is very usable in current form, but > still there are some issu

Re: [Proposal] Global temporary tables

2020-07-13 Thread wenjing zeng
> 2020年7月10日 下午5:03,wenjing zeng 写道: > > HI all > > I started using my personal email to respond to community issue. > > > >> 2020年7月7日 下午6:05,Pavel Stehule > <mailto:pavel.steh...@gmail.com>> 写道: >> >> Hi >> >> GTT