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

From: Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>
To: John R Pierce <pierce(at)hogranch(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postgres.exe Process taking too much memory and CPU usage - making the system extremely slow.
Date: 2009-12-12 02:17:49
Message-ID: db471ace0912111817g7c6ab323k206e489223c9259f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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,.

Fair enough, but I wasn't actually advocating that as a solution to
the poster's problem. I was merely pointing out that it isn't strictly
true that there is an absolute limit of 2GB of addressable memory for
user processes in 32-bit XP.

Regards,
Peter Geoghegan

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2009-12-12 03:35:17 Re: Installing PL/pgSQL by default
Previous Message Glen Barber 2009-12-11 21:14:31 Re: Restore time differences between full database dumps and separate schema/data dumps