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

Поиск
Список
Период
Сортировка
От STERBECQ Didier
Тема PgAdmin 4 : how to avoid error "Out of memory for query result"during SELECT with LOB ?
Дата
Msg-id C0685475FF6E374E989150721491820A18925EA2@SV003314.info.ratp
обсуждение исходный текст
Ответы Re: PgAdmin 4 : how to avoid error "Out of memory for query result"during SELECT with LOB ?  (Khushboo Vashi <khushboo.vashi@enterprisedb.com>)
Список pgadmin-support

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 ?

 

Thanks by advance.

 

Didier Sterbecq.

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

Предыдущее
От: siddhartha attri
Дата:
Сообщение: Re: pgadmin very slow
Следующее
От: Khushboo Vashi
Дата:
Сообщение: Re: PgAdmin 4 : how to avoid error "Out of memory for query result"during SELECT with LOB ?