Re: Large Pages and Super Pages for PostgreSQL

[ZHU XIAN WEN]

Hi Thomas

Thank you very much for the work.

I just got latest FreeBSD 13.1 environment, and I'm going to test and 
verify it.


so would you please rebase latest patch?

best wishes

Tony

On 2022/11/8 06:59, Thomas Munro wrote:

On Sun, Jan 16, 2022 at 8:32 PM Thomas Munro  wrote:

On Sun, Jan 16, 2022 at 6:03 PM DEVOPS_WwIT  wrote:

Solaris and FreeBSD supports large/super pages, and can be used
automatically by applications.

Seems Postgres can't use the large/super pages on Solaris and FreeBSD
os(I think can't use the large/super page HPUX and AIX), is there anyone
could take a look?

3.  FreeBSD: FreeBSD does transparently migrate PostgreSQL memory to
"super" pages quite well in my experience, but there is also a new
facility in FreeBSD 13 to ask for specific page sizes explicitly.  I
wrote a quick and dirty patch to enable PostgreSQL's huge_pages and
huge_page_size settings to work with that interface, but I haven't yet
got as far as testing it very hard or proposing it...  but here it is,
if you like experimental code[2].

I was reminded to rebase that and tidy it up a bit, by recent
discussion of page table magic in other threads.  Documentation of
these interfaces is sparse to put it mildly (I may try to improve that
myself) but basically the terminology is "super" for pages subject to
promotion/demotion, and "large" when explicitly managed.  Not
proposing for commit right now as I need to learn more about all this
and there are some policy decisions lurking in here (eg synchronous
defrag vs nowait depending on flags), but the patch may be useful for
experimentation.  For example, it allows huge_page_size=1GB if your
system can handle that.


OpenPGP_0x6A40B0F18DBF5A23.asc
Description: OpenPGP public key


OpenPGP_signature
Description: OpenPGP digital signature

Re: [Proposal] Global temporary tables

[ZHU XIAN WEN]

Hi WenJing


Thanks for the feedback,

I have tested the code, it seems okay, and regression tests got pass

and I have reviewed the code, and I don't find any issue anymore


Hello all


Review and comments for the patches V51 is welcome.


if there is no feedback, I'm going to changed the status to 'Ready for
Committer' on Aug 25


big thanks

Tony



On 2021/7/29 23:19, wenjing zeng wrote:
>
>> 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 
> 
> If you have any questions, please give me feedback.
>
>
> Wenjing
>
>
>> Thank you very much
>> Tony
>>
>> The new status of this patch is: Waiting on Author
>



OpenPGP_signature
Description: OpenPGP digital signature