PgAdmin 4 : how to avoid error "Out of memory for query result"during SELECT with LOB ? - Mailing list pgadmin-support

From STERBECQ Didier
Subject PgAdmin 4 : how to avoid error "Out of memory for query result"during SELECT with LOB ?
Date
Msg-id C0685475FF6E374E989150721491820A18925EA2@SV003314.info.ratp
Whole thread Raw
Responses Re: PgAdmin 4 : how to avoid error "Out of memory for query result"during SELECT with LOB ?  (Khushboo Vashi <khushboo.vashi@enterprisedb.com>)
List 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 by date:

Previous
From: siddhartha attri
Date:
Subject: Re: pgadmin very slow
Next
From: Khushboo Vashi
Date:
Subject: Re: PgAdmin 4 : how to avoid error "Out of memory for query result"during SELECT with LOB ?