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

On Wed, Jan 29, 2020 at 6:37 PM STERBECQ Didier <didier(dot)sterbecq(at)ratp(dot)fr>
wrote:

> Hi,
>
> When I wrote “SET fetch_count 1 ” in query tool of PgAdmin, i get error
>
Oops, I missed that fetch_count only works for psql.
I found a way which might help you -
https://www.linuxtopia.org/online_books/database_guides/Practical_PostgreSQL_database/PostgreSQL_r27008.htm
In this, FETCH clause is used to fetch N rows at a time. I tried in pgAdmin
on a table, seems to be working.

> ERROR: unrecognized configuration parameter "fetch_count"
>
> SQL state: 42704
>
>
>
> When I write “\SET fetch_count 1”, I get error:
>
> ERROR: syntax error at or near "\"
>
>
>
> How to fix that ?
>
> Thanks by advance.
>
>
>
> Didier Sterbecq
> Ingéniérie de Brique Technique - SIT/S2IP/ACI/IBT
>
> ------------------------------------------------------------
>
> RATP - Département des systèmes d'information et de télécommunications
>
> Lac NA40 - NYLG
>
> 102 Esplanade de la Commune de Paris
>
> 93160 Noisy-le-Grand
>
> Tél : 01 58 7*8 81 78*
>
> GSM *: 06 17 45 17 32*
> *didier(dot)sterbecq(at)ratp(dot)fr <didier(dot)sterbecq(at)ratp(dot)fr>*
>
>
>
> *De :* Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com>
> *Envoyé :* mercredi 29 janvier 2020 13:48
> *À :* STERBECQ Didier <didier(dot)sterbecq(at)ratp(dot)fr>
> *Cc :* Khushboo Vashi <khushboo(dot)vashi(at)enterprisedb(dot)com>;
> 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,
>
>
>
> You can run SET FETCH_COUNT 1 in pgAdmin query tool also, which will be
> applicable to that session only similar to psql.
>
>
>
> On Wed, Jan 29, 2020 at 5:28 PM STERBECQ Didier <didier(dot)sterbecq(at)ratp(dot)fr>
> wrote:
>
> 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>
> 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.
>
>
>
>
> --
>
> Thanks and Regards,
>
> Aditya Toshniwal
>
> pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune
>
> "Don't Complain about Heat, Plant a TREE"
>

--
Thanks and Regards,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Engineer | EnterpriseDB India | Pune
"Don't Complain about Heat, Plant a TREE"