Hi everyone, I have a largish table (> 8GB). I'm doing a very simple single group by on. I am the only user of this database. If I set work mem to anything under 2GB (e.g. 1900MB) the postmaster process stops at that value while it's peforming it's group by. There is only one hash operation so that is what I would expect. But anything larger and it eats up all memory until it can't get anymore (around 7.5GB on a 8GB machine). Has anyone experienced anything of this sort before. Cheers -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
