Re: Supporting huge pages on Windows - Mailing list pgsql-hackers

From Tsunakawa, Takayuki
Subject Re: Supporting huge pages on Windows
Date
Msg-id 0A3221C70F24FB45833433255569204D1F5F9E54@G01JPEXMBYT05
Whole thread Raw
In response to Re: Supporting huge pages on Windows  (Andres Freund <andres@anarazel.de>)
Responses Re: Supporting huge pages on Windows  (Haribabu Kommi <kommi.haribabu@gmail.com>)
List pgsql-hackers
From: Thomas Munro [mailto:thomas.munro@enterprisedb.com]
> Your ~2.4% number is similar to what was reported for Linux with 4GB
> shared_buffers:
> 
> https://www.postgresql.org/message-id/20130913234125.GC13697%40roobarb
> .crazydogs.org

I'm relieved to know that a similar figure was gained on Linux.  Thanks for the info.


> Later in that thread there was a report of a dramatic ~15% increase in "best
> result" TPS, but that was with 60GB of shared_buffers on a machine with
> 256GB of RAM:
> 
> https://www.postgresql.org/message-id/20131024060313.GA21888%40toroid.
> org

From: Andres Freund [mailto:andres@anarazel.de]
> FWIW, I've seen 2-3x increases with ~60GB of s_b.

Wow, nice figures.  It's unfortunate that I don't have such a big machine available at hand.

Regards
Takayuki Tsunakawa




pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: Macro customizable hashtable / bitmapscan & aggregation perf
Next
From: Noah Misch
Date:
Subject: Re: "Re: Question about grant create on database and pg_dump/pg_dumpall