The following bug has been logged on the website:
Bug reference: 8687
Logged by: Peter Sylvester
Email address: peters(at)mitre(dot)org
PostgreSQL version: 9.3.2
Operating system: CENTOS6
Description:
I have a query which causes out of memory conditions with a HashAggregate
plan.
The query involves a join between a 10M row table and a 1K row table,
work_mem=300MB, process space goes over 6GB then machine runs out of memory
and swap and the OS kills the back end process.
I have a test script which I can upload to recreate the issue.