BUG #14840: Issues and bad performance with 9.6.5

Started by Nonameover 8 years ago3 messagesbugs
Jump to latest
#1Noname
drabant@nexgo.de

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Noname (#1)
Re: BUG #14840: Issues and bad performance with 9.6.5

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

#3David G. Johnston
david.g.johnston@gmail.com
In reply to: Tom Lane (#2)
Re: BUG #14840: Issues and bad performance with 9.6.5

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