Re: Out of memory error in 8.1.0 Win32

"Relyea, Mike" <Mike.Relyea@xerox.com> writes:
> I've zipped the results of EXPLAIN INSERT INTO "tblSummary" SELECT *
> FROM "qrySummary"; for my case.  It's a zip file that I've renamed to
> .txt in order to get around the attachment being blocked by certain mail
> servers.

Egad, what a mess :-(.  By my count you have 89 hash joins, 24 sorts,
and 8 hash aggregations in there.  In total these will feel authorized
to use 121 times work_mem.  Since you've got work_mem set to 256 meg,
an out-of-memory condition doesn't seem that surprising.  You need to
make work_mem drastically smaller for this query.  Or else break it down
into multiple steps.

            regards, tom lane