Re: Out of Memory Error on Insert

Mark Priest <mark(dot)priest(at)computer(dot)org> writes:
> I am getting an Out of Memory error in my server connection process
> while running a large insert query.

> Postgres version: "PostgreSQL 8.2.16 on i686-pc-mingw32, compiled by
> GCC gcc.exe (GCC) 3.4.2 (mingw-special)"
> OS: Windows 7 Professional (v.6.1, build 7601 service pack 1)
> The OS is 64 bit but the postgres app is a 32-bit app and I run out of
> memory and the server process crashes as soon as I hit 2 GB of memory.

FWIW, I see excessive memory consumption for this query in 8.2.x but
not in 8.3.x and later. Some desultory investigation suggests that
the change is associated with rangetable representation improvements
that were made in 8.3. Since 8.2.x is staring hard at its EOL date,
I suggest now might be a good time to update to a more recent release
series.

regards, tom lane