Database contains 300 million records and the select query expects 120,620 records as result.

This is the log message:
Out of memory: Kill process 30650 (mserver5) score 981 or sacrifice child
Killed process 30650, UID 222, (mserver5) total-vm:35263192kB, anon-rss:14911384kB, file-rss:208kB

mserver5 version:
MonetDB 5 server v11.15.11 "Feb2013-SP3" (64-bit, 64-bit oids)
Copyright (c) 1993-July 2008 CWI
Copyright (c) August 2008-2013 MonetDB B.V., all rights reserved
Visit http://www.monetdb.org/ for further information
Found 14.5GiB available memory, 4 available cpu cores
Libraries:
  libpcre: 7.8 2008-09-05 (compiled with 7.8)
  openssl: OpenSSL 1.0.0 29 Mar 2010 (compiled with OpenSSL 1.0.0-fips 29 Mar 2010)
  libxml2: 2.7.6 (compiled with 2.7.6)
Compiled by: ec2-user@ip-10-252-152-159 (x86_64-unknown-linux-gnu)
Compilation: gcc -g -O2
Linking    : /usr/bin/ld -m elf_x86_64

Filesystem        Size  Used      Avail     Use%  Mounted on
/dev/xvde1         5.0G  2.4G     2.4G      50%      /
tmpfs                 7.3G     0        7.3G      0%        /dev/shm
/dev/xvdf            414G  209G  184G     54%      /media/ephemeral0 (dbfarm)