Postgres Pro
Downloads
Home   >   mailing lists

Re: psql leaks memory on query cancellation - Mailing list pgsql-hackers

From Darafei "Komяpa" Praliaskouski
Subject Re: psql leaks memory on query cancellation
Date
Msg-id CAC8Q8tKw3uRg0GBN7ESpktFGipJSPMaVWcV+WuzwBMHpdkPwFA@mail.gmail.com
Whole thread Raw
In response to Re: psql leaks memory on query cancellation  (Craig Ringer <craig@2ndquadrant.com>)
List pgsql-hackers
Tree view

> Is it expected behavior (so I can have a look at something server returned
> somehow and it's kept there for me), or a plain leak?

This is totally normal behaviour for any C program.
 
Thanks Konstantin and Craig for the help.

To mitigate the issue I've changed the allocator on my laptop to jemalloc.
For single psql run on my Ubuntu system:

sudo apt install libjemalloc1
LD_PRELOAD=/usr/lib/x86_64-linux-gnu/libjemalloc.so.1 psql

A global replacement by putting /usr/lib/x86_64-linux-gnu/libjemalloc.so.1 to /etc/ld.so.preload also had a positive effect fixing this behavior in all the applications, reducing after-boot memory footprint from 7 GB to 3.

Darafei Praliaskouski, 
GIS Engineer / Juno Minsk

pgsql-hackers by date:

Previous
From: Aleksander Alekseev
Date:
Subject: Re: Covering GiST indexes
Next
From: "Jonathan S. Katz"
Date:
Subject: Re: Boolean partitions syntax