On Wed, Jan 29, 2020 at 6:37 PM STERBECQ Didier <didier.sterb...@ratp.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.sterb...@ratp.fr <didier.sterb...@ratp.fr>* > > > > *De :* Aditya Toshniwal <aditya.toshni...@enterprisedb.com> > *Envoyé :* mercredi 29 janvier 2020 13:48 > *À :* STERBECQ Didier <didier.sterb...@ratp.fr> > *Cc :* Khushboo Vashi <khushboo.va...@enterprisedb.com>; > pgadmin-support@lists.postgresql.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.sterb...@ratp.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.va...@enterprisedb.com> > *Envoyé :* mercredi 29 janvier 2020 05:54 > *À :* STERBECQ Didier <didier.sterb...@ratp.fr> > *Cc :* pgadmin-support@lists.postgresql.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.sterb...@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. > > > > > -- > > 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"
