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

[Stephan Knauss]

On 03.04.2021 20:50, Stephan Knauss wrote:
> 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

I was able to identify PostgreSQL JIT as the source of the memory leak. 
It is unclear why it leaks and which queries trigger it. Upstream 
discusses a lead in Bug 16707.

Other reports with osm2pgsql reported that our workload does not go well 
with JIT.

So best would be to turn off JIT completely at the moment.

Stephan