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

Hi,

I set ON_DEMAND_RECORD_COUNT to 50, in the config.py file, with restart of PgAdmin,
but I get same error “ERROR: out of memory for query result”.
For information, the result set contains 279 rows.
When I use the LIMIT clause in the SELECT order, error raise near 150, but I do not test all values to find the edge.

Thanks by advance for your help.
Didier Sterbecq

De : Khushboo Vashi <khushboo(dot)vashi(at)enterprisedb(dot)com>
Envoyé : mercredi 29 janvier 2020 05:54
À : STERBECQ Didier <didier(dot)sterbecq(at)ratp(dot)fr>
Cc : pgadmin-support(at)lists(dot)postgresql(dot)org
Objet : Re: PgAdmin 4 : how to avoid error "Out of memory for query result" during SELECT with LOB ?

Hi,

On Tue, Jan 28, 2020 at 9:25 PM STERBECQ Didier <didier(dot)sterbecq(at)ratp(dot)fr<mailto:didier(dot)sterbecq(at)ratp(dot)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.