Search Postgresql Archives

Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Peter Geoghegan wrote:
Incidentally, I seem to recall that there is a way of using greater
than 2GB of memory on 32-bit XP; It's a matter of turning on the
so-called "3gb switch":

http://www.microsoft.com/whdc/system/platform/server/PAE/PAEmem.mspx

which is suicide on the typical x86 32bit system that has max 3.2GB (+/-) addressable physical memory[1], never mind the issues it causes with reduced space for page tables and such.

if you read through all the microsoft KB articles and stuff on that flag, it was recommended for use only under tightly controlled circumstances, like a 32bit windows server that was dedicated to running 1-2 specific apps that were OK with it,.





[1] yes the hardware probably supports PAE to access physical memory above 4GB via page table extensions, but XP 32bit doesn't.

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux