David Hinkle <hin...@cipafilter.com> writes: > Thanks guys, here's the information you requested: > psql:postgres@cipafilter = show work_mem; > work_mem > ────────── > 10MB > (1 row)
[ squint... ] It should absolutely not have tried to hash a 500M-row table if it thought work_mem was only 10MB. I wonder if there's an integer-overflow problem or something like that. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general