I just tried on OSX Lion and the problem is reproduced there. The RSIZE in top increases to about 1GB in less than a minute. The Python version on Lion is 2.7.1
I can also reproduce on Ubuntu 10.04.4 which is Python 2.6.5 Ron On Thursday, 19 April 2012 10:23:50 UTC-7, nick name wrote: > > On Wednesday, April 18, 2012 10:26:32 PM UTC-4, Massimo Di Pierro wrote: >> >> In order to isolate the problem, let's check if this is a sqlite:memory >> issue. Can you reproduce the problem with sqlite://storage.db ? >> > > Yes, same result exactly. Note that the 'storage.db' is empty, but I'm > seeing this in production, with a real database full of data. (This short > script was my result of trying to track this down from a real world problem) > > Perhaps it happens more slowly on the Mac, but I'm surprised it doesn't > happen. Massimo, did you try to leave it running for (e.g.) 10 minutes and > check the memory consumption? Or maybe you have a VPS with python on to try? >

