[MAPSERVER-USERS] postgres transaction warnings

Colin Wetherbee cww at denterprises.org
Thu Feb 28 19:39:02 EST 2008


rich.fromm wrote:
> Oh yeah, I do have for each LAYER:
>    PROCESSING	"CLOSE_CONNECTION=DEFER"

I have found this leaves transactions open quite often.  It prevents my 
application from updating the database, so I've turned it off.  Which 
decreases performance, but at least I don't have stale transactions 
sitting around everywhere and hanging my application.

Closing those transactions when they're finished would certainly be nice.

Colin


More information about the mapserver-users mailing list