Re: PgAdmin 4 : how to avoid error "Out of memory for query result"during SELECT with LOB ?

Поиск
Список
Период
Сортировка
От Khushboo Vashi
Тема Re: PgAdmin 4 : how to avoid error "Out of memory for query result"during SELECT with LOB ?
Дата
Msg-id CAFOhELericYzsG7K1Taffps7JLQW6zE9utFUrvnX_ih-XzkU1w@mail.gmail.com
обсуждение исходный текст
Ответ на PgAdmin 4 : how to avoid error "Out of memory for query result"during SELECT with LOB ?  (STERBECQ Didier <didier.sterbecq@ratp.fr>)
Ответы RE: PgAdmin 4 : how to avoid error "Out of memory for query result"during SELECT with LOB ?  (STERBECQ Didier <didier.sterbecq@ratp.fr>)
Список pgadmin-support
Дерево обсуждения
Hi,

On Tue, Jan 28, 2020 at 9:25 PM STERBECQ Didier <didier.sterbecq@ratp.fr> wrote:

Hi,

 

I am running pgAdmin 4 version 4.15, with PostgreSQL 9.3 database,  and during SELECT on table with LOB (in TOAST), after near 5 minutes of wait I get error “Ouf of memory for query result”.

Adding  LIMIT clause in SQL work well, but I want all the rows of the result set.

I understand that with psql command I can use “\SET FETCH_COUNT 1” to avoid such error, but what to do with PgAdmin 4 ?

 

You can limit the number of records to fetch in one batch by changing the ON_DEMAND_RECORD_COUNT variable in the config.py file.
You can override this setting to the appropriate number (default is 1000) in the config_local.py or config_distro.py file.
The details regarding configuration file is at https://www.pgadmin.org/docs/pgadmin4/4.17/config_py.html#config-py 

Thanks,
Khushboo

Thanks by advance.

 

Didier Sterbecq.

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

Предыдущее
От: STERBECQ Didier
Дата:
Сообщение: PgAdmin 4 : how to avoid error "Out of memory for query result"during SELECT with LOB ?
Следующее
От: STERBECQ Didier
Дата:
Сообщение: RE: PgAdmin 4 : how to avoid error "Out of memory for query result"during SELECT with LOB ?