Re: PgAdmin 4 : how to avoid error "Out of memory for query result"during SELECT with LOB ?
От | Aditya Toshniwal |
---|---|
Тема | Re: PgAdmin 4 : how to avoid error "Out of memory for query result"during SELECT with LOB ? |
Дата | |
Msg-id | CAM9w-_n=YETKvKGZMA-U8ym_x+UoNVj26rDbXBe0KouTSnG5yA@mail.gmail.com обсуждение исходный текст |
Ответ на | RE: PgAdmin 4 : how to avoid error "Out of memory for query result"during SELECT with LOB ? (STERBECQ Didier <didier.sterbecq@ratp.fr>) |
Список | pgadmin-support |
Hi,
When I wrote “SET fetch_count 1 ” in query tool of PgAdmin, i get error
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 78 81 78
GSM : 06 17 45 17 32
didier.sterbecq@ratp.fr
De : Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>
Envoyé : mercredi 29 janvier 2020 13:48
À : STERBECQ Didier <didier.sterbecq@ratp.fr>
Cc : Khushboo Vashi <khushboo.vashi@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.sterbecq@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.vashi@enterprisedb.com>
Envoyé : mercredi 29 janvier 2020 05:54
À : STERBECQ Didier <didier.sterbecq@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.sterbecq@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"
В списке pgadmin-support по дате отправления:
Предыдущее
От: STERBECQ DidierДата:
Сообщение: RE: PgAdmin 4 : how to avoid error "Out of memory for query result"during SELECT with LOB ?