2015-06-11 23:20 GMT+09:00 Jan Wieck <j...@wi3ck.info>: > On 06/11/2015 09:53 AM, Kouhei Kaigai wrote: >>> >>> curious: what was work_mem set to? >>> >> work_mem=48GB >> >> My machine mounts 256GB physical RAM. > > > work_mem can be allocated several times per backend. Nodes like sort and > hash_aggregate may each allocate that much. You should set work_mem to a > fraction of physical-RAM / concurrent-connections depending on the > complexity of your queries. 48GB does not sound reasonable. > Smaller number of max_connections and large work_mem configuration are usual for typical OLAP workloads.
Even if configuration is not reasonable, it is not a right error message. People cannot understand how to fix it. psql:query21.sql:50: ERROR: invalid memory alloc request size 1073741824 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
