Re: Trim the heap free memory

2024-09-17 Thread shawn wang
Thank you very much for your response and suggestions. As you mentioned, the patch here is actually designed for glibc's ptmalloc2 andis not applicable to other platforms. I will consider supporting it only on the Linux platform in the future. In the memory management strategy of ptmalloc2, there

Re: Trim the heap free memory

2024-09-15 Thread shawn wang
have any further insights or recommendations, I would greatly appreciate your guidance. Thank you once again for your support. Best regards, Shawn David Rowley 于2024年9月12日周四 16:42写道: > On Thu, 12 Sept 2024 at 14:40, shawn wang wrote: > > Could you please perform another round of t

Re: Trim the heap free memory

2024-09-11 Thread shawn wang
; ^~ > 1 error generated. > > On Wed, 28 Aug 2024 at 12:54, shawn wang wrote: > >> Hi Ashutosh, >> >> Ashutosh Bapat 于2024年8月26日周一 19:05写道: >> >>> Hi Shawn, >>> It will be good to document usage of this function. Please

Re: Trim the heap free memory

2024-08-28 Thread shawn wang
ents: 100 > number of threads: 100 > maximum number of tries: 1 > duration: 600 s > number of transactions actually processed: 470690787 > number of failed transactions: 0 (0.000%) > latency average = 0.127 ms > initial connection time = 23.632 ms > tps = 784511.901558

Re: Trim the heap free memory

2024-08-23 Thread shawn wang
has included the omitted code. Ashutosh Bapat 于2024年8月23日周五 20:02写道: > Hi Shawn, > > > On Fri, Aug 23, 2024 at 2:24 PM shawn wang > wrote: > > > > Hi hackers, > > > > Currently, all processes in PostgreSQL actually use malloc to allocate > and free mem

Re: Trim the heap free memory

2024-08-23 Thread shawn wang
Thank you Rafia. Here is a v2 patch. Rafia Sabih 于2024年8月23日周五 18:30写道: > > > On Fri, 23 Aug 2024 at 10:54, shawn wang wrote: > >> Hi hackers, >> >> Currently, all processes in PostgreSQL actually use malloc to allocate >> and free memory. In the case of lon

Trim the heap free memory

2024-08-23 Thread shawn wang
trimming heap free memory of PID > 68673 > pg_trim_backend_heap_free_memory > -- > t > (1 row) > 02b65000-082e5000 rw-p 00:00 0 > [heap] > Size: 89600 kB > KernelPageSize:4 kB > MMUPageSize: 4 kB > Rss:4888 kB > Pss:4888 kB postgres 68673 1.2 0.0 610456 75244 ?Ss 08:26 0:01 > postgres: postgres postgres [local] idle > Looking forward to your feedback, Regards, -- Shawn Wang Now trimheapfreemeory.patch Description: Binary data

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 postgre

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 c

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 thi

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: > > He

Re: WIP: Data at rest encryption

2019-08-01 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 encrypt

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 multi-leve