Re: Content assist / autocomplete hangs the server (latest pgAdmin version)

Thanks Akshay, that's what I meant by "switched autocomplete to manual".

That however doesn't really address the issue. I can still bring down the
pgAdmin backend (for everyone using it) by clicking Ctrl+Space on a
complex/rogue SQL.

On Fri, Aug 5, 2022 at 4:35 AM Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com>
wrote:

> Hi Cherio
>
> You can disable the automatic autocomplete option from "File ->
> Preferences -> Query Tool -> Auto completion -> Autocomplete on key press".
> We have also fixed an issue to stop autocomplete on arrow keys #7573
> <https://redmine.postgresql.org/issues/7573> which will be available in
> the next release, meanwhile, you can install the snapshot build
> <https://www.postgresql.org/ftp/pgadmin/pgadmin4/snapshots/>.
>
>
>
> On Wed, Aug 3, 2022 at 11:39 PM Cherio <cherio(at)gmail(dot)com> wrote:
>
>> I had to examine certain aspects of a query that looks like this:
>>
>> SELECT COUNT(*)
>> FROM schema.table
>> WHERE id IN (
>> '1',
>> '2',
>> '3',
>> ....
>> '19998',
>> '19999',
>> '20000'
>> )
>>
>> I pasted the query and autocomplete kicked in. For a minute it froze
>> entirely. Then it sort of let me do things but everything was like in slow
>> motion: the tree browser, the other SQL tabs - everything became slow as
>> molasses. I logged onto the server and the "pgAdmin4.py" was
>> keeping the CPU quite busy. It didn't recover for some time so I simply
>> restarted the server and switched autocomplete to manual.
>>
>> Not knowing the design I may not be able to make a viable suggestion but
>> maybe some sort of complexity counter (configurable or at least hard-coded
>> at first) should be considered, which would hint to the autocomplete to
>> stop trying, after it realizes the task may be too complex or takes too
>> long to complete.
>>
>> Sure, a query like the one above should probably make use of a temporary
>> table but it is beyond the point - there has to be a safeguard against an
>> overloaded autocomplete. Without such a safeguard an ugly/invalid query or
>> a user error could kill the server for all connected pgadmin clients.
>>
>>>
>
> --
>
> <http://www.enterprisedb.com>
>
> Akshay Joshi
>
> Principal Software Architect
>
> +91 9767888246
>
> www.enterprisedb.com
>
> <https://www.linkedin.com/company/edbpostgres>
> <https://twitter.com/edbpostgres?lang=en>
> <https://www.facebook.com/EDBpostgres>
> <https://www.instagram.com/EDBpostgres/>
>