From: | Khushboo Vashi <khushboo(dot)vashi(at)enterprisedb(dot)com> |
---|---|
To: | STERBECQ Didier <didier(dot)sterbecq(at)ratp(dot)fr> |
Cc: | "pgadmin-support(at)lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org> |
Subject: | Re: PgAdmin 4 : how to avoid error "Out of memory for query result" during SELECT with LOB ? |
Date: | 2020-01-29 04:54:06 |
Message-ID: | CAFOhELericYzsG7K1Taffps7JLQW6zE9utFUrvnX_ih-XzkU1w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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.
>
From | Date | Subject | |
---|---|---|---|
Next Message | STERBECQ Didier | 2020-01-29 11:58:22 | RE: PgAdmin 4 : how to avoid error "Out of memory for query result" during SELECT with LOB ? |
Previous Message | STERBECQ Didier | 2020-01-28 15:55:34 | PgAdmin 4 : how to avoid error "Out of memory for query result" during SELECT with LOB ? |