David Hinkle <hinkle(at)cipafilter(dot)com> writes:
> Thanks guys, here's the information you requested:
> psql:postgres(at)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