[sqlalchemy] set next value of postgres sequence

2015-11-27 Thread Chris Withers
Hi All, What's the recommended way to set the next value of a postgres sequence when using sqlalchemy? cheers, Chris -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an

Re: [sqlalchemy] Re: memory of query cache not release when session close

2015-11-27 Thread Mike Bayer
On 11/27/2015 05:20 AM, Hongxin Song wrote: > In multithreaded scenarios , it is a serious problem , because the > server will be oom that's part of CPython, first see: http://effbot.org/pyfaq/why-doesnt-python-release-the-memory-when-i-delete-a-large-object.htm so once you use 2G of RAM,

[sqlalchemy] Re: Creating a derived class object without inserting into base class table

2015-11-27 Thread Jonathan Vanasco
On Wednesday, November 25, 2015 at 5:01:38 PM UTC-5, amit geron wrote: > In Flask-SQLAlchemy there are default table names, and in this case they > would be just 'User', 'A' and 'B', which are already unique. > flask-sqlachemy doesn't overrwrite this feature of SqlAlchemy. See this

[sqlalchemy] memory of query cache not release when session close

2015-11-27 Thread Hongxin Song
when I query a lot of record from mysql by session.query, which is one million more, and the size of memory reaches to 2G Byte , I want to release the

[sqlalchemy] Re: memory of query cache not release when session close

2015-11-27 Thread Hongxin Song
In multithreaded scenarios , it is a serious problem , because the server will be oom 在 2015年11月27日星期五 UTC+8下午4:44:50,Hongxin Song写道: > > > > > > when I query