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

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow.
Дата
Msg-id 4B22944B.2070005@hogranch.com
обсуждение исходный текст
Ответ на Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow.  (Peter Geoghegan <peter.geoghegan86@gmail.com>)
Ответы Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow.  (Peter Geoghegan <peter.geoghegan86@gmail.com>)
Список pgsql-general
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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: pg_dump and ON DELETE CASCADE problem
Следующее
От: Glen Barber
Дата:
Сообщение: Re: Restore time differences between full database dumps and separate schema/data dumps