subject:"\[sqlalchemy\] Hoarded RAM"

Re: [sqlalchemy] Hoarded RAM

2020-07-02 Thread Mike Bayer

On Thu, Jul 2, 2020, at 12:21 PM, Massimiliano della Rovere wrote: > Greetings, > I am using > * SQLAlchemy: 1.3.3 > * psycopg2-binary: 2.8.3 > * postgresql: 9.6 > > While running a SQLAlchemy CORE script that makes lots of updates (about > 300k), some inserts (about 50k) and commits data only

[sqlalchemy] Hoarded RAM

2020-07-02 Thread Massimiliano della Rovere

Greetings, I am using * SQLAlchemy: 1.3.3 * psycopg2-binary: 2.8.3 * postgresql: 9.6 While running a SQLAlchemy CORE script that makes lots of updates (about 300k), some inserts (about 50k) and commits data only at the end, the script consumes about 8GB+ RAM (well... we have to stop it to avoid