Bert <bier...@gmail.com> writes:
> These are my memory settings:
> work_mem = 4GB
> How is it possible that one connection (query) uses all the ram? And how
> can I avoid it?
Uh ... don't do the above. work_mem is the allowed memory consumption
per query step, ie per hash or sort operation. A complex query can
easily use multiples of work_mem.
regards, tom lane
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
