Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Largepages in Windows - Mailing list pgsql-general

From Andrew Kerber
Subject Re: [GENERAL] Largepages in Windows
Date
Msg-id CAJvnOJY9qdUf8Fjbf8G6CXSjYEKGjo6SaWLB8VNxYqezc9SCvw@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] Largepages in Windows  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
Oh, I can answer that.  The owner of the postgreSQL executable must have the privilege to lock pages in memory.

On Tue, Jan 17, 2017 at 9:38 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Andrew Kerber <andrew.kerber@gmail.com> writes:
> Does PostgreSQL 9.4 support large pages in windows?  The setting is there
> in the postgresql.conf, but I cant tell if it is supported in windows?

No, but there's a pending patch for that:

https://www.postgresql.org/message-id/flat/0A3221C70F24FB45833433255569204D1F5F1751@G01JPEXMBYT05

Looks like it's blocked on the question of what privileges are required
to use the feature.

                        regards, tom lane



--
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] Largepages in Windows
Next
From: kumar s
Date:
Subject: [GENERAL] Fwd: [webmaster] Update query issue