[MAPSERVER-USERS] postgres transaction warnings

Colin Wetherbee cww at denterprises.org
Thu Feb 28 16:39:02 PST 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