From: | Bill Moran <wmoran(at)potentialtech(dot)com> |
---|---|
To: | Tom Wilcox <hungrytom(at)googlemail(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Out of Memory and Configuration Problems (Big Computer) |
Date: | 2010-05-28 15:34:01 |
Message-ID: | 20100528113401.88e4011c.wmoran@potentialtech.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
In response to Tom Wilcox <hungrytom(at)googlemail(dot)com>:
<snip>
> Also, can anyone give me any pointers for configuring postgres to use
> ALL 96GB of RAM in my new machine? I would like to know it was using
> everything available.. especially when it is possible to load an entire
> 30m row table into memory! I am currently using the default
> configuration from standard installation.
>
> Any help/suggestions are very much appreciated.
There is a LOT of information missing from this email, such as PG
version and the OS it's running on.
As a starter, though, the default config is not appropriate for most
workloads, and is certainly not optimal for a machine with 96G of RAM.
Start out by following any of the dozens of PG tuning howtos to get
your basic memory setting set up. For example:
http://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
--
Bill Moran
http://www.potentialtech.com
http://people.collaborativefusion.com/~wmoran/
From | Date | Subject | |
---|---|---|---|
Next Message | Alban Hertroys | 2010-05-28 15:45:22 | Re: Config Changes Broke Postgres Service (Windows) |
Previous Message | Tom Wilcox | 2010-05-28 14:49:25 | Re: Config Changes Broke Postgres Service (Windows) |