Re: out of memory problem

Pruteanu Dragos wrote:
> Hi all,
>
> I am running Postgres on a machine with
> 4G of memory.
> When I run
> dbvlm=> SELECT u.email, g.email FROM dom_user u,

> shared_buffers = 200000
> sort_mem = 819200
> vacuum_mem = 819200

What process led you to choose these values? Do you understand the
implications of allocating 1.6GB of memory to shared buffers, along with
over 800MB per sort?

> Any ideea what can be done?

Start by fixing your configuration values - the above are unlikely to be
correct. Then, check to see if all RAM is actually in use, or you have
hit some system-imposed per-user limit.

This might be a useful place to start:
http://www.powerpostgresql.com/PerfList
--
Richard Huxton
Archonet Ltd