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
On Mon, Oct 2, 2017 at 6:36 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
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 withwith
very little number of columns. After deinstallation of 9.6.5 and
re-installation of 9.5.4 theses issues disappeared. Any suggestions howto
solve these issues with 9.6.5?
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.