This doesn't look right to me: postgres=# set work_mem='1GB'; SET postgres=# show work_mem; work_mem ---------- 1MB (1 row)
-- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster