On Fri, Apr 1, 2016 at 2:53 AM, Andrew Dunstan <and...@dunslane.net> wrote: > It would also be nice to find out why we can't usefully scale shared buffers > higher like we can on *nix.
Has anyone ever looked into whether asking for SEC_LARGE_PAGES would help with that? I noticed that another popular RDBMS recommends enabling this to see a gain when its buffer pool is "several gigabytes". I don't do Windows myself, but from poking around in the docs, it looks like you need to grant SeLockMemoryPrivilege (Start > Control Panel > Administrative Tools > Local Security Policy > User Rights Assignment > Lock pages in memory > Action > Properties) because large pages can't be swapped out (just like on other OSs). So maybe it could work like huge_pages = try on Linux so that it works out of the box with 4K pages, but starts using 2MB (?) pages if you grant SeLockMemoryPrivilege. https://msdn.microsoft.com/en-us/library/windows/desktop/aa366543(v=vs.85).aspx Just a thought. -- Thomas Munro http://www.enterprisedb.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
