[OSM-dev] posgresql/postgis leaking memory in tirex rendering setup

[Stephan Knauss]

On 30.03.2021 21:04, Darafei "Komяpa" Praliaskouski wrote:
> What we'll need is a way to reproduce the issue. Just "tirex" is not 
> enough, a docker-compose with all the scripts running or isolated 
> query that causes the leak will help. At the very least - enable a 
> full log of queries with auto_explain and zero threshold and attach 
> the postgresql.log with all these, so we have something to look into.


I have a file with full queries and auto_explain here:

https://downloads.osm-tools.org/postgresql-2021-04-03_183913.csv.gz


During the run the RssAnon of the backend did increase by roughly 10MB. 
I hope such a short log is fine. As tile rendering is executing similar 
queries just with different data, I assume it is sufficient.

If you need something in addition, please let me know.


Stephan