Re: Is it worth pushing conditions to sublink/subplan?

2021-08-31 Thread shawn wang
I tested it the way you said and increased the number of sub-tables. I created a hash partition table of 1000 sub-tables. Test according to your first SQL, the optimizer cuts the unnecessary sub-tables well. You can see the plan: postgres=# explain analyze postgres-# select temp.p1 from

Re: [Proposal] Global temporary tables

2021-04-15 Thread shawn wang
wenjing 于2021年4月15日周四 下午3:26写道: > HI Pavel > > I added user documentation. > Please give me feedback. > > > Wenjing > > Hi, Wenjing, I have checked your documentation section and fixed a spelling mistake, adjusted some sentences for you. All the modified content is in the new patch, and please

Re: ECPG: proposal for new DECLARE STATEMENT

2020-11-16 Thread Shawn Wang
The following review has been posted through the commitfest application: make installcheck-world: tested, passed Implements feature: tested, passed Spec compliant: tested, passed Documentation:tested, passed Recently I have been doing some work on ecpg. So I review

Re: [bug] Table not have typarray when created by single user mode

2020-05-21 Thread Shawn Wang
The following review has been posted through the commitfest application: make installcheck-world: tested, passed Implements feature: tested, passed Spec compliant: tested, passed Documentation:not tested I verified and found no problems.

Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS)

2019-11-10 Thread shawn wang
to generate kek; use the -D option to get cluster encryption, walkey, and relkey. 2. pg_waldump adds wal decryption function 3. pg_rewind adds wal decryption function 4. pg_resetwal adds wal encryption Regards, -- Shawn Wang Masahiko Sawada 于2019年10月31日周四 下午10:25写道: > On Fri, Sep 6, 2019 a

Re: WIP: Data at rest encryption

2019-09-04 Thread Shawn Wang
On Wed, 04 Sep 2019 00:56:15 +0800 Alvaro Herrera <mailto:alvhe...@2ndquadrant.com> wrote On 2019-Aug-02, Shawn Wang wrote: > Hi Antonin, > It is very glad to see the new patch. I used the public patches a long time > ago. > I did some tests like the stream

Re: Problem with default partition pruning

2019-08-08 Thread Shawn Wang
will continue to pay attention to this and will follow up and feedback in time. Regards,   --  Shawn Wang On Thu, 27 Jun 2019 10:34:13 +0800 yuzuko wrote Hello, On Tue, Jun 25, 2019 at 1:45 PM yuzuko <mailto:yuzukohos...@gmail.com> wrote: > > Hello S

Re: WIP: Data at rest encryption

2019-08-02 Thread Shawn Wang
. There is some problem to merge your patches to the latest kernel in the pg_ctl.c. Regards, -- Shawn Wang

Re: Problem with default partition pruning

2019-06-23 Thread shawn wang
essage-id/attachment/100591/v3_ignore_contradictory_where_clauses_at_partprune_step.patch> . Otherwise, you will find some errors. I hope this helps you. Regards. -- Shawn Wang Alvaro Herrera 于2019年6月22日周六 上午4:03写道: > On 2019-Jun-17, Shawn Wang wrote: > > > I tested different types

Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS)

2019-06-18 Thread shawn wang
Masahiko Sawada 于2019年6月17日周一 下午8:30写道: > On Fri, Jun 14, 2019 at 7:41 AM Tomas Vondra > wrote: > > I personally find the idea of encrypting tablespaces rather strange. > > Tablespaces are meant to define hysical location for objects, but this > > would also use them to "mark" objects as

Re: Problem with default partition pruning

2019-06-16 Thread Shawn Wang
The following review has been posted through the commitfest application: make installcheck-world: tested, failed Implements feature: tested, passed Spec compliant: not tested Documentation:not tested Hi Hosoya-san, I tested different types of key values, and