Re: Jsonb transform for pl/python

Поиск
Список
Период
Сортировка
Искать
От
Nikita Glukhov
Тема
Re: Jsonb transform for pl/python
Дата
Msg-id
b14b08f2-6598-b386-46f7-cd577383d54f@postgrespro.ru
Ответ на
Список
Дерево обсуждения
[HACKERS] Jsonb transform for pl/python Anthony Bykov <a.bykov@postgrespro.ru>
Re: [HACKERS] Jsonb transform for pl/python David Fetter <david@fetter.org>
Re: [HACKERS] Jsonb transform for pl/python Anthony Bykov <a.bykov@postgrespro.ru>
Re: [HACKERS] Jsonb transform for pl/python David Fetter <david@fetter.org>
Re: [HACKERS] Jsonb transform for pl/python Aleksander Alekseev <a.alekseev@postgrespro.ru>
Re: [HACKERS] Jsonb transform for pl/python Anthony Bykov <a.bykov@postgrespro.ru>
Re: Jsonb transform for pl/python Aleksander Alekseev <a.alekseev@postgrespro.ru>
Re: Jsonb transform for pl/python Anthony Bykov <a.bykov@postgrespro.ru>
Re: Jsonb transform for pl/python Aleksander Alekseev <a.alekseev@postgrespro.ru>
Re: Jsonb transform for pl/python Anthony Bykov <a.bykov@postgrespro.ru>
Re: Jsonb transform for pl/python Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Jsonb transform for pl/python Anthony Bykov <a.bykov@postgrespro.ru>
Re: Jsonb transform for pl/python Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Jsonb transform for pl/python Tom Lane <tgl@sss.pgh.pa.us>
Re: Jsonb transform for pl/python Thomas Munro <thomas.munro@enterprisedb.com>
Re: Jsonb transform for pl/python Anthony Bykov <a.bykov@postgrespro.ru>
Re: Jsonb transform for pl/python Aleksander Alekseev <a.alekseev@postgrespro.ru>
Re: Jsonb transform for pl/python Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Jsonb transform for pl/python Nikita Glukhov <n.gluhov@postgrespro.ru>
Re: Jsonb transform for pl/python Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Jsonb transform for pl/python Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Jsonb transform for pl/python Nikita Glukhov <n.gluhov@postgrespro.ru>
Re: Jsonb transform for pl/python Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Jsonb transform for pl/python Nikita Glukhov <n.gluhov@postgrespro.ru>
Re: Jsonb transform for pl/python Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Jsonb transform for pl/python Tom Lane <tgl@sss.pgh.pa.us>
Re: Jsonb transform for pl/python Alexander Korotkov <a.korotkov@postgrespro.ru>
Re: Jsonb transform for pl/python Nikita Glukhov <n.gluhov@postgrespro.ru>
Re: Jsonb transform for pl/python Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: Jsonb transform for pl/python Michael Paquier <michael.paquier@gmail.com>
Working on the new lazy transform for jsonb I found another memory leak in
PLyObject_ToJsonbValue(): palloc() for output boolean JsonbValue is unnecessary,
'out' variable is already initialized.

Fix is attached.

On 15.06.2018 14:42, Alexander Korotkov wrote:
> Hi!
>
> On Fri, Jun 15, 2018 at 2:11 PM Nikita Glukhov  wrote:
>
> I found a memory leak in PLySequence_ToJsonbValue():
> PyObject returned from PySequence_GetItem() is not released.
>
> A bug can be easily reproduced using function roudtrip() from regression test:
> SELECT roundtrip('[1,2,3]'::jsonb) FROM generate_series(1, 1000000);
>
> Similar code in PLyMapping_ToJsonbValue() seems to be correct because
> PyList_GetItem() and PyTuple_GetItem() return a borrowed reference.
>
> Patch with fix is attached.
> I'm going to check and commit this if everything is OK.
>
> ------
> Alexander Korotkov
> Postgres Professional: http://www.postgrespro.com
> The Russian Postgres Company

-- 
Nikita Glukhov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company
В списке pgsql-hackers по дате отправления
От: Jesper Pedersen
Дата:
Сообщение: Re: executor relation handling
От: Alexander Kuzmenkov
Дата:
Сообщение: buildfarm and git pull
FAQ