Thread: out of memory problem

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,
dom_member m, dom_group g
andlm-> WHERE u.userid=m.userid and
m.groupid=g.groupid and g.iso_language='de' and
dbvlm-> m.type='n' limit 1000;
ERROR:  out of memory
DETAIL:  Failed on request of size 68.
dbvlm=>

The postgres settings are
# - Memory -



shared_buffers = 200000
sort_mem = 819200
vacuum_mem = 819200




Any ideea what can be done?
Thank you
Dragos Pruteanu






__________________________________
Celebrate Yahoo!'s 10th Birthday!
Yahoo! Netrospective: 100 Moments of the Web
http://birthday.yahoo.com/netrospective/

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