Postgres Pro
Downloads
Home   >   mailing lists

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

From Andres Freund
Subject Re: Supporting huge pages on Windows
Date
Msg-id 20161010210043.ynnm7yxgsjlre3qo@alap3.anarazel.de
Whole thread Raw
In response to Re: Supporting huge pages on Windows  (Thomas Munro <thomas.munro@enterprisedb.com>)
Responses Re: Supporting huge pages on Windows  ("Tsunakawa, Takayuki" <tsunakawa.takay@jp.fujitsu.com>)
List pgsql-hackers
Tree view 
On 2016-10-11 09:57:48 +1300, Thomas Munro wrote:
> 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

FWIW, I've seen 2-3x increases with ~60GB of s_b.

Andres

pgsql-hackers by date:

Previous
From: Thomas Munro
Date:
Subject: Re: Supporting huge pages on Windows
Next
From: Tom Lane
Date:
Subject: Re: Switch to unnamed POSIX semaphores as our preferred sema code?