[web2py] Re: Web2py scheduler linked postgres processes consuming too much memory

2016-07-29 Thread Abhishek Ram
I have tested it and I can now confirm that the issue is with pg8000. I think its a good idea to mention this in the WIKI. On Friday, July 29, 2016 at 12:12:07 AM UTC+5:30, Niphlod wrote: > > could you please try with psycopg2 ? > > On Thursday, July 28, 2016 at 6:53:10 PM UTC+2, Abhishek Ram

[web2py] Re: Web2py scheduler linked postgres processes consuming too much memory

2016-07-29 Thread Massimo Di Pierro
The pg8000 driver has problems. Sorry. We should remove it from web2py. On Thursday, 28 July 2016 11:53:10 UTC-5, Abhishek Ram wrote: > > I am using the default driver pg8000 > > On Thursday, July 28, 2016 at 7:47:41 PM UTC+5:30, Niphlod wrote: >> >> what driver are you using ? it's rather

[web2py] Re: Web2py scheduler linked postgres processes consuming too much memory

2016-07-28 Thread Niphlod
could you please try with psycopg2 ? On Thursday, July 28, 2016 at 6:53:10 PM UTC+2, Abhishek Ram wrote: > > I am using the default driver pg8000 > > On Thursday, July 28, 2016 at 7:47:41 PM UTC+5:30, Niphlod wrote: >> >> what driver are you using ? it's rather strange that postrgresql acts up

[web2py] Re: Web2py scheduler linked postgres processes consuming too much memory

2016-07-28 Thread Abhishek Ram
I am using the default driver pg8000 On Thursday, July 28, 2016 at 7:47:41 PM UTC+5:30, Niphlod wrote: > > what driver are you using ? it's rather strange that postrgresql acts up > and eat all the available memory, if you didn't tinker with the defaults > settings of postgresql... > > On

[web2py] Re: Web2py scheduler linked postgres processes consuming too much memory

2016-07-28 Thread Niphlod
what driver are you using ? it's rather strange that postrgresql acts up and eat all the available memory, if you didn't tinker with the defaults settings of postgresql... On Wednesday, July 27, 2016 at 5:09:34 AM UTC+2, Abhishek Ram wrote: > > Well the memory leak was from the postgres

[web2py] Re: Web2py scheduler linked postgres processes consuming too much memory

2016-07-26 Thread Abhishek Ram
Well the memory leak was from the postgres processes spawned by the web2py scheduler process. I am sure about this as I have seen TOP and confirmed that it was these processes that were consuming the memory. I even tried with a basic app and the postgres processes continued to consume memory.

[web2py] Re: Web2py scheduler linked postgres processes consuming too much memory

2016-07-18 Thread Niphlod
you're seeing a totally normal thing: postgresql spawns a different process for each connection. Those processes in linux are fork()s, so even if you SEEM to notice a skyrocket in memory utilization summing all different processes (e.g. in "top"), in reality it's not sucking up every bit of