[Tile-serving] [openstreetmap/mod_tile] memory consumption (#181)

[Paul Norman]

> I found an interesting post regarding **long running connections**:
> 
> > The most likely cause for this is that PostgreSQL keeps a **per-connection cache** of metadata about all the database objects (tables, indexes, etc.) it has touched during the connection lifetime. **There is no upper limit** on how big this cache can get, and no mechanism for expiring it.
> > (https://dba.stackexchange.com/questions/160887/how-can-i-find-the-source-of-postgresql-per-connection-memory-leaks/222815#222815)
> 
> The usual solutions seems is to set a maximum life time for a single connection. Is there such an option in renderd?

It is unlikely this is the problem, because most rendering databases contain a small number of large objects, not many small objects.

-- 
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/mod_tile/issues/181#issuecomment-735946352
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20201130/78c1afe3/attachment.htm>