Fix use of transactions only where needed and review how connections are returned to the pool for PostgreSQL

Currently we return the connection to the pool by using the commit() call. My current understanding is that this needs to be called even if we perform just non transactional queries, in which case the commit() call will not do any DB commit, just release the connection to the pool. This is a bit confusing and should be reviewed.