psql leaks memory on query cancellation

Поиск
Список
Период
Сортировка
От Darafei "Komяpa" Praliaskouski
Тема psql leaks memory on query cancellation
Дата
Msg-id CAC8Q8tJ=7cOkPePyAbJE_Pf691t8nDFhJp0KZxHvnq_uicfyVg@mail.gmail.com
обсуждение исходный текст
Ответы Re: psql leaks memory on query cancellation  (Konstantin Knizhnik <k.knizhnik@postgrespro.ru>)
Re: psql leaks memory on query cancellation  (Craig Ringer <craig@2ndquadrant.com>)
Список pgsql-hackers
Hi,

psql (PostgreSQL) 10.3

Here are the steps to reproduce a leak:

1. connect to 10.3 server, perform the query similar to:

select 'message' || generate_series(1,1000000000);

2. monitoring psql memory usage in htop or similar tool, press ctrl+c at some point where you can clearly distinguish a psql with a big allocated buffer from psql without it.

3. see the query cancelled, but psql memory usage stays the same.

This is especially painful when query you're debugging has a runaway join condition, and you understand it only after it doesn't return in seconds as you've expected.

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?

Darafei Praliaskouski, 
GIS Engineer / Juno Minsk

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Alexander Korotkov
Дата:
Сообщение: Re: Partitioned tables and covering indexes
Следующее
От: Andrey Borodin
Дата:
Сообщение: Covering GiST indexes