Bert <biertie@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
