Re: [GENERAL] Postgresql out of memory during big transaction

2014-09-16 Thread Tom Lane
Marc Van Olmen writes: > [ out of memory while ] >* trying to import about 20GBytes of data (40K rows + rest large image > blob's) > What I notice is that the python app stays around 200Mbytes of memory usage, > but the postgres process on my MacOSX 10.9.5 is growing and growing. Until it

[GENERAL] Postgresql out of memory during big transaction

2014-09-16 Thread Marc Van Olmen
Trying to debug an out of memory error with Postgresql. Simple: * Open Connection * begin transaction * trying to import about 20GBytes of data (40K rows + rest large image blob's) * end transaction * Close Connection What I notice is that the python app stays around 200Mbytes of memory us