Mark Priest <mark.priest@xxxxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
