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

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/>