[Tile-serving] [osm2pgsql-dev/osm2pgsql] Set timeout for idle transactions at session level (Discussion #2290)

[Jochen Topf]

Generally osm2pgsql should not hold open connections for a long time and the situation should have improved with changes in recent versions. This goes double for sessions that have a transaction open. Open sessions use ressources while they are open, but more importantly open transactions can lead to bloat.

I think we should first try to get the root cause solved in the application or at least try to figure out how long we need this timeout to be before setting this. It would help if you can give us more info about the situation where this happens, i.e. which connection is the problem. If you enable debug logging, you'll hopefully get more information on when this happens.

-- 
Reply to this email directly or view it on GitHub:
https://github.com/osm2pgsql-dev/osm2pgsql/discussions/2290#discussioncomment-11818085
You are receiving this because you are subscribed to this thread.

Message ID: <osm2pgsql-dev/osm2pgsql/repo-discussions/2290/comments/11818085 at github.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20250113/dc3e7d26/attachment-0001.htm>