public inbox for [email protected]
help / color / mirror / Atom feedFrom: Dave Page <[email protected]>
To: Aditya Toshniwal <[email protected]>
Cc: pgadmin-hackers <[email protected]>
Subject: Re: Regarding multiple result set in query tool
Date: Thu, 25 Sep 2025 15:25:26 +0100
Message-ID: <CA+OCxoybXgPbEAK+xdHQyAeFPmwXU+Tb4h0ZNHRPLVvTdtcDBw@mail.gmail.com> (raw)
In-Reply-To: <CAM9w-_koTeoUazBctc=cTTEn3HeRE2gYNETNGtJp3ZTr3gLdSw@mail.gmail.com>
References: <CAM9w-_mQsC--AfLuEbv0NbW_p_b=PTD0ZbQr8J2Vv=2ioDp_gw@mail.gmail.com>
<CA+OCxowcJNADQdbrzX9qxtOt+8qAS36tcYyE=-tcdQFWGqzVQw@mail.gmail.com>
<CAM9w-_mbXuLXhJKB7KMBvqsCLeKkC2ubcAcxuVq7KR8DzqB_zA@mail.gmail.com>
<CA+OCxozF-kD5=AsuaX10_Kh1sBpM3stSsPC7-RGLYpx=a_ahJQ@mail.gmail.com>
<CAM9w-_mSHJuKE1HJceDOQqxZe1Yq4DaYG6fxMeAooY=8xBvgGA@mail.gmail.com>
<CA+OCxoyO2FNEqa1aw8Czvpjv15qiN5Uk17Sbwc1+2t4B-JTsZA@mail.gmail.com>
<CAM9w-_koTeoUazBctc=cTTEn3HeRE2gYNETNGtJp3ZTr3gLdSw@mail.gmail.com>
On Thu, 25 Sept 2025 at 14:44, Aditya Toshniwal <
[email protected]> wrote:
> Hi Dave,
>
>>
>> If pgAdmin were a single-user application, I'd agree - however it is not
>> when running in server mode. Other users will not know what is going on if
>> one user exhausts memory.
>>
> How about allowing multi result sets only for desktop app?
>
I *really* dislike that. We should support all features in both modes,
except where it clearly doesn't make sense.
> The problem with memory limits is - it's an extra overhead to keep
> checking how much memory is consumed. A row size will depend on the number
> of columns and data. If we have a predefined algorithm which will decide
> the limits in a performant way is desirable.
>
Well we can take the extra cycles to compute actual memory usage, or we can
just pick an arbitrary number of rows (which as you note, will depend on
the schema and data). The former is clearly easier to tune - it could be an
arbitrary limit in the config, or it could be computed based on machine
resources and utilisation, whilst the latter is always going to be a guess.
I'm not sure I see another way. Anyone else?
--
Dave Page
pgAdmin: https://www.pgadmin.org
PostgreSQL: https://www.postgresql.org
pgEdge: https://www.pgedge.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Regarding multiple result set in query tool
In-Reply-To: <CA+OCxoybXgPbEAK+xdHQyAeFPmwXU+Tb4h0ZNHRPLVvTdtcDBw@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox