Forgot to include pgsql-general@lists.postgresql.org in the Cc...
-------- Forwarded Message --------
Subject: Re: PgAdmin is struggling and can we configure it so that it
works better
Date: Fri, 21 Jan 2022 13:42:13 +0100
From: Tomas Pospisek <tpo2@sourcepole.ch>
To: Shaozhong SHI <shishaozhong@gmail.com>
On 21.01.22 12:42, Shaozhong SHI wrote:
> Some time, PgAdmin freezes and its response is very slow.
>
> Some time, it gives strange display of table content. Perhaps, it is
> related to the fact that PgAdmin is struggling with the amount of data
> it thinks that it has to display.
>
> I just wonder whether we can configure PgAdmin so that it will work better.
You can compare the times the same query takes to display the result
locally via PgAdmin and remotely, when you execute the same query on
that server with psql. That will give you an idea on whether the long
execution time is on the server or not.
*t