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

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Peter Geoghegan <peter(dot)geoghegan86(at)gmail(dot)com>
Cc: "Massa, Harald Armin" <chef(at)ghum(dot)de>, Dave Page <dpage(at)pgadmin(dot)org>, 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-11 14:42:38
Message-ID: 4B225A5E.5050909@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Using 3GB user address space may have side effects. Some drivers
(particularly graphics drivers for high-end graphics cards) may not be
happy, for example. It's best used with caution if at all.

These days, if you need it, you're better off just going 64-bit.

--
Craig Ringer

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Robert Gottstein 2009-12-11 15:09:26 Transaction read command fetching of single Data Items
Previous Message Alvaro Herrera 2009-12-11 14:12:13 Re: PIVOT tables and crosstab