RE: [Patch] Optimize dropping of relation buffers using dlist - Mailing list pgsql-hackers

From tsunakawa.takay@fujitsu.com
Subject RE: [Patch] Optimize dropping of relation buffers using dlist
Date
Msg-id OSBPR01MB298225226D471B01E3D0F97EFE0B0@OSBPR01MB2982.jpnprd01.prod.outlook.com
Whole thread Raw
In response to RE: [Patch] Optimize dropping of relation buffers using dlist  ("k.jamison@fujitsu.com" <k.jamison@fujitsu.com>)
List pgsql-hackers
From: Jamison, Kirk/ジャミソン カーク <k.jamison@fujitsu.com>
> With the latest patches attached, and removing the recovery check in
> smgrnblocks, I tested the performance of vacuum.
> (3 trial runs, 3.5 GB db populated with 1000 tables)
> 
> Execution Time (seconds)
> | s_b   | master | patched | %reg     |
> |-------|--------|---------|----------|
> | 128MB | 15.265 | 15.260  | -0.03%   |
> | 1GB   | 14.808 | 15.009  | 1.34%    |
> | 20GB  | 24.673 | 11.681  | -111.22% | 100GB | 74.298 | 11.724  |
> | -533.73% |
> 
> These are good results and we can see the improvements for large shared
> buffers, For small s_b, the performance is almost the same.

Very nice!

I'll try to review the patch again soon.


Regards
Takayuki Tsunakawa


pgsql-hackers by date:

Previous
From: "tsunakawa.takay@fujitsu.com"
Date:
Subject: RE: POC: postgres_fdw insert batching
Next
From: Greg Nancarrow
Date:
Subject: Re: Parallel copy