This is probably not a web2py question, but here goes anyway. I'm migrating to postgres from having prototyped with sqlite. Besides a few instances where I had reference fields defaulting to 0 instead of None, the migration went smoothly. BUT, I'm having the database get locked up all the time whenever I need to delete and sometimes update certain records. Ironically, sqlite doesn't do that even though the main impetus for migrating to postgres was because I was under the impression that it was less likely to get into a locked condition.
Is there some special setting I need that will cause postgres to be less likely to lock up? i'm setting the pool_size=20 already. Anything else I need to be doing? Thx.
