On Thu, Jun 20, 2013 at 6:12 AM, Manuel Kniep <rapimo@adeven.com> wrote:
Hello,
I have table with 37 million entries the whole table has a size of 2.3 GB
Although I have set the work_mem to 10 GB
There is one piece of memory used in in-memory sorting that (currently) has to be a single contiguous allocation, and that piece is limited to 1GB. This means you can't always use the entire amount of work_mem declared, especially when sorting a very large number of very short rows, as you seem to be doing.
There is another "rounding" issue that means sometimes as little as 512MB of that 1GB is actually used. This part is probably fixed for 9.3.