Sort by DB size takes a very long time
There seems to be a "suboptimal" implementation of the "Statistics" page when it comes to sorting. I experienced it when sorting by DB "Size" field but it looks like the problem to a lesser extent exists when sorting by other fields as well. Steps to reproduce: 1. Click on the "Databases" node; it should have multiple databases to work 2. Select "statistics" tab 3. Click to sort on the "Size" column In my case it took about 40 seconds to sort 13 databases, including "postgres" DB [image: image.png]
Re: i need help
Hi, Type the following in your terminal with the user that can access the database: psql -c 'SHOW config_file' regards, Bastiaan On Fri, 12 Feb 2021 at 11:05, Ralf Bezzenberger wrote: > I am on localhost and I don't find postgresql.conf. > > Mit freundlichen Grüßen, > > Dr. Ralf Bezzenberger > > Senior IT Consultant > New Data Solutions > Consumer Products > > msg systems ag > Robert-Bürkle-Str. 1 > 85737 Ismaning > Deutschland > > Mobil: +49 1511 7488310 > E-Mail: ralf.bezzenberger@msg.group > > http://www.msg.group > > Sitz der Gesellschaft: 85737 Ismaning/München > Vorstand: Dr. Stephan Frohnhoff (Vorsitzender), Rolf Kranz, Bernhard Lang, > Dr. Aristid Neuburger, Karsten Redenius, Dr. Frank Schlottmann, Dr. > Jürgen Zehetmaier > Aufsichtsratsvorsitzender: Johann Zehetmaier > Handelsregister: Amtsgericht München, HRB 140 149 > > Bitte beachten Sie, dass der Inhalt dieser E-Mail vertraulich zu behandeln > ist. Sofern Sie nicht der beabsichtigte Adressat sind, dürfen wir Sie > bitten, uns umgehend zu benachrichtigen und den Inhalt dieser E-Mail zu > löschen. > > > -Ursprüngliche Nachricht- > Von: Ray O'Donnell > Gesendet: Donnerstag, 11. Februar 2021 17:13 > An: Ralf Bezzenberger ; > pgadmin-support@lists.postgresql.org > Betreff: Re: i need help > > On 11/02/2021 15:53, Ralf Bezzenberger wrote: > > Hallo, > > > > I am using pgAdmin 4.30 and have the following problem: > > > > I had a server running and then removed it. When trying to add a new > > server with the same name I get the message that localhost:5432 cannot > > be connected (see Attachment). > > > > Using netstat tell me there is no process on that port. > > Is the PostgreSQL server on localhost or on a remote machine? > > If it's localhost, check the port which it's listening on - it might be > something other than 5432. You should find this in postgresql.conf. > > Ray. > > -- > Raymond O'Donnell // Galway // Ireland > r...@rodonnell.ie > > >
AW: i need help
I am on localhost and I don't find postgresql.conf. Mit freundlichen Grüßen, Dr. Ralf Bezzenberger Senior IT Consultant New Data Solutions Consumer Products msg systems ag Robert-Bürkle-Str. 1 85737 Ismaning Deutschland Mobil: +49 1511 7488310 E-Mail: ralf.bezzenberger@msg.group http://www.msg.group Sitz der Gesellschaft: 85737 Ismaning/München Vorstand: Dr. Stephan Frohnhoff (Vorsitzender), Rolf Kranz, Bernhard Lang, Dr. Aristid Neuburger, Karsten Redenius, Dr. Frank Schlottmann, Dr. Jürgen Zehetmaier Aufsichtsratsvorsitzender: Johann Zehetmaier Handelsregister: Amtsgericht München, HRB 140 149 Bitte beachten Sie, dass der Inhalt dieser E-Mail vertraulich zu behandeln ist. Sofern Sie nicht der beabsichtigte Adressat sind, dürfen wir Sie bitten, uns umgehend zu benachrichtigen und den Inhalt dieser E-Mail zu löschen. -Ursprüngliche Nachricht- Von: Ray O'Donnell Gesendet: Donnerstag, 11. Februar 2021 17:13 An: Ralf Bezzenberger ; pgadmin-support@lists.postgresql.org Betreff: Re: i need help On 11/02/2021 15:53, Ralf Bezzenberger wrote: > Hallo, > > I am using pgAdmin 4.30 and have the following problem: > > I had a server running and then removed it. When trying to add a new > server with the same name I get the message that localhost:5432 cannot > be connected (see Attachment). > > Using netstat tell me there is no process on that port. Is the PostgreSQL server on localhost or on a remote machine? If it's localhost, check the port which it's listening on - it might be something other than 5432. You should find this in postgresql.conf. Ray. -- Raymond O'Donnell // Galway // Ireland r...@rodonnell.ie