Re: [GENERAL] Out of Memory Error on Insert

2011-10-18 Thread Mark Priest
g the disk at some point to reduce memory usage. Could it be that postgres tries to keep temp tables in memory? On Tue, Oct 18, 2011 at 3:56 AM, Craig Ringer wrote: > On 10/18/2011 02:52 PM, Mark Priest wrote: >> >> I am getting an Out of Memory error in my server connection p

Fwd: [GENERAL] Out of Memory Error on Insert

2011-10-18 Thread Mark Priest
h a > query but I am surprised that postgres doesn't start using the disk at > some point to reduce memory usage. Could it be that postgres tries > to keep temp tables in memory? > On Tue, Oct 18, 2011 at 3:56 AM, Craig Ringer wrote: >> On 10/18/2011 02:52 PM, Mark Prie

[GENERAL] Out of Memory Error on Insert

2011-10-17 Thread Mark Priest
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 t