Обсуждение: [BUGS] BUG #14840: Issues and bad performance with 9.6.5
The following bug has been logged on the website: Bug reference: 14840 Logged by: Drabant Email address: drabant@nexgo.de PostgreSQL version: 9.5.4 Operating system: Windows 10, 64 bit Description: PostgreSQL v 9.5.4 (with pgAdmin III) works fine. However upgrading to 9.6.5 (with pgAdmin 4) yields loads of issues. In general the new version is by far slower, initializing queries takes ages even for small tables with with very little number of columns. After deinstallation of 9.6.5 and re-installation of 9.5.4 theses issues disappeared. Any suggestions how to solve these issues with 9.6.5? -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
drabant@nexgo.de writes: > PostgreSQL v 9.5.4 (with pgAdmin III) works fine. However upgrading to 9.6.5 > (with pgAdmin 4) yields loads of issues. In general the new version is by > far slower, initializing queries takes ages even for small tables with with > very little number of columns. After deinstallation of 9.6.5 and > re-installation of 9.5.4 theses issues disappeared. Any suggestions how to > solve these issues with 9.6.5? https://wiki.postgresql.org/wiki/Slow_Query_Questions regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
drabant@nexgo.de writes:
> PostgreSQL v 9.5.4 (with pgAdmin III) works fine. However upgrading to 9.6.5
> (with pgAdmin 4) yields loads of issues. In general the new version is by
> far slower, initializing queries takes ages even for small tables with with
> very little number of columns. After deinstallation of 9.6.5 and
> re-installation of 9.5.4 theses issues disappeared. Any suggestions how to
> solve these issues with 9.6.5?
https://wiki.postgresql.org/wiki/Slow_Query_Questions
This doesn't sound like a complaint about slow queries but rather a poor experience with pgAdmin4. The pgadmin-support@postgresql.org list is the place to voice those concerns. You will want to ensure you are using the newest patch release of pgAdmin4 as it is in active development and many fixes are happening presently, especially relating to usability and performance of the program itself.
David J.